The tag has no usage guidance.

learn more… | top users | synonyms

15
votes
2answers
8k views

I need to run VACUUM FULL with no available disk space

I have one table that is taking up close to 90% of hd space on our server. I have decided to drop a few columns to free up space. But I need to return the space to the OS. The problem, though, is ...
14
votes
2answers
13k views

Why doesn't DELETE + REORG free diskspace (DB2)?

In DB2 I have a table containing large binary data. Now i purged the whole table and ran runstats, reorg, runstats, but the amount of disk space taken does not change. What could be wrong here? The ...
10
votes
6answers
52k views

Shrinking the log file does not reduce size

I have a database which had mdf size of 350 MB and ldf size 4.9 GB When i try to shrink the log file it's not shrinking. I know shrinking a database is not good and it should not be done. But still i ...
10
votes
1answer
5k views

How can I determine the size of a dump file prior to dumping?

How can I determine or estimate the size of the SQL dump file prior to using something like mysqldump?
10
votes
3answers
3k views

PostgreSQL Initial Database Size

There are 2 parts to my question. Is there a way of specifying the initial size of a database in PostgreSQL? If there isn't, how do you deal with fragmentation when the database grows over time? I'...
8
votes
1answer
5k views

MySQL Workbench Database Sizes

I'm trying to find the total size on the hard disk that all of my MySQL Workbench databases are using. Does anyone know of an easy way to figure this out? If nothing else, the default location mysql/...
6
votes
1answer
657 views

Using an RDBMS for querying tens of Terabytes of time-series data?

I stumbled over an algorithmic / data-structures question over on SO, which I'll short quote: (...) opinions regarding best of breed data structures to be used for indexing time-series (aka ...
5
votes
3answers
2k views

what is causing arithmetic overflow in the query below? [closed]

when I run the following query on MY_Database select * from sys.sysfiles I get the following results: But when I run a dynamic query that gets the percent of free space I get: Msg 8115, ...
5
votes
2answers
5k views

Proper storage size estimation technique for PostgreSQL

We are preparing a PostgreSQL database for production usage and we need to estimate the storage size for this database. We are a team of developers with low expertise on database administration, so we ...
5
votes
1answer
712 views

PostgreSQL relation size does not sum up

I have a very large table, with blob fields, called data. I've tried to figure out why it isn't cached well and repeated SELECTs are quite slow: => SELECT pg_size_pretty(pg_total_relation_size('...
5
votes
2answers
841 views

Postgres reported table / db size varies wildly from dump size

I have a very strange misreporting of the size of one specific database. According to \l+ in psql the DB size is 292 MB. Doing a sum over the sizes reported by the following statement also reports ...
4
votes
2answers
3k views

Manually increase PostgreSQL's table size limit of 32 TB?

I need a free database software and thought of PostgreSQL. But then I read it has a table size limit of 32 terabytes, but I need more (and don't want to spend thousand/millions on high end database ...
4
votes
2answers
13k views

Estimate a Database Size

I have to do some project, and need to estimate the DB size. I'm gonna to use Oracle in the project, because will have a lot of transactions and size. But in the "presentation" I need to specify, in 5 ...
4
votes
1answer
6k views

How do I get the size of a Vertica database?

I have a Vertica database. How can I tell how big the database is? I need a rough answer for the purposes of reporting basic statistics about our environment to upper management.
4
votes
4answers
1k views

Are junction tables a good practice?

Say I have a large table that holds the user's info and another table that holds several locations. Then I use another table that holds the user_id and the location_id. In order to retrieve the data ...
4
votes
3answers
4k views

SQL Server 2008 R2 Express size

I have what I believe is SQL Server 2008 R2 Express installed on a production server. When I connect to it with SQL Server Management Studio it shows up as SQL Server 10.50.1600. If it is in fact SQL ...
4
votes
1answer
718 views

Oracle Database 12c: Unable to resize system tablespace

Problem: My java application is returning ORA-01691: unable to extend lob segment errors for every insert Cause: After running: SELECT * FROM dba_tablespace_usage_metrics ORDER BY used_percent ...
4
votes
1answer
869 views

What are all the reasons/possibilities that may fail to release disk space occupied by TEMPORARY table?

We're using PostgreSQL v8.2.3. Ours is a web-based application and we're using pgpool-II v 2.0.1 purely for connection pooling (we don't use other features of pgpool like Replication, Load Balancing, ...
3
votes
1answer
77 views

How can I verify that my SQL Server edition is Express? [closed]

I have a SQL Server (version 11.0.5058). I tried to restore a database from a bak file and I got an error saying: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative ...
3
votes
2answers
2k views

Find the largest databases on my server

I have several hundred databases running on the same MySQL server. How can I get a list sorted by the size of the databases?
3
votes
1answer
149 views

How many blocks is my database

How can I write a query using Oracle SQL Developer to find how many blocks my database is using? (tables & indexes)
3
votes
1answer
2k views

Performance effects of database file size and available space

I have set the autogrowth and maxsize properties to: By 10 MB, Unlimited When I look at the Properties -> General Tab by right-clicking the database in SSMS, I see the file size is 2249MB with 6.1 ...
3
votes
2answers
1k views

My database dramatically increased in size. Why?

I found that my database, specifically the USERS tablespace, dramatically increased in size. How can I find what DML operations are performing on the objects located in this tablespace?
3
votes
1answer
605 views

Postgres: check disk space taken by materialized view?

I know how to check the size of indexes and tables in Postgres (I'm using version 9.4): SELECT relname AS objectname, relkind AS objecttype, reltuples AS "#entries", pg_size_pretty(relpages::...
3
votes
2answers
8k views

Acceptable size for MS Access Database?

I have developed an Access 2010 database. It has three main tables: HOUSES id, address, number_stories, garden, parking, imageAttachments (~1-4 per record), etc..., about 60 fields total ...
3
votes
1answer
334 views

Why does an sqlite3 .dump and restore result in a smaller database file size?

I have a really naive question about database file sizes. I started out with a 1.2M SQLite database, dumped it to a SQL file, and then restored it to a new database. The restored database file was ...
2
votes
1answer
2k views

How to handle huge table

We have a problem with a few tables that are very very big slowing down the system. so my question is if that size is normal for the amount of rows in the table, and also what could be done to make it ...
2
votes
1answer
253 views

Delete log to increase DB space?

I'm running SQL Server 2008 Express and hitting the 4GB size wall. I'd like to make some space to give me time before i migrate to a larger DB. I don't need my transaction log. So, can i delete ...
2
votes
2answers
1k views

Huge disk space usage increase when altering a column

I hope this question is easy for someone to answer :) I have a table that looks like this (unimportant columns hidden) CREATE TABLE [dbo].[Log]( [LogID] [int] IDENTITY(1,1) NOT NULL, --...
2
votes
2answers
833 views

PostgreSQL: Separate tables vs single table to perserve disk space?

I have 2 tables with the below schemas with equal number of rows. When I run the SELECT relname, relpages FROM pg_class ORDER BY relpages DESC command, they show up as 23GB each even though the data ...
2
votes
1answer
131 views

Querying True Physical Database File Sizes

On querying database file sizes... 1) Most if not all of these answers do not always match the physical file size shown in file explorer: http://stackoverflow.com/questions/5945360 The accepted ...
2
votes
1answer
607 views

Database schema size result differs from file size when exported

I used this query to find out my database size SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY ...
2
votes
1answer
2k views

How to estimate database size needed?

I work on a transaction banking service project, and we need to have a central database to keeping client's info, account info, transaction details, etc. So, how can I estimate the size of database ...
2
votes
0answers
774 views

TempDB MDF file huge after update script ran

On the weekend we had a huge deployment run that affected a large chunk of our system. It was all run in one massive transaction (probably the wrong thing to do). As a result our TempDB DatabaseFile ...
1
vote
2answers
460 views

Shrinking sql databases - bad idea? [duplicate]

I have a database, that due to some silly code issues has grown hugely. It is now sitting at 24GB, most of it is very unnecessary logging information (system generated debug information). My server ...
1
vote
3answers
359 views

Show data and disk use breakdown by table

I have a SQL Server 2008 R2 database being used by several deployed programs. Question: Is there an easy way to display how much space each table consumes, for all of the tables in the database, and ...
1
vote
1answer
322 views

Size of an empty database

Continuing with my school-project, now I have to estimate the size of the database from here to 5 years. They give me a formula, so, in that formula, one of the values is the size of the empty ...
1
vote
1answer
4k views

How to know DB size using backup file without restoring it

Is there anyway so that we can estimated/know size of database using backup file without restoring it?
1
vote
1answer
94 views

Does INFORMATION_SCHEMA always contain up-to-date metadata?

This query prints the size (in terms of data and indexes) of the tables in mydatabase: SELECT table_name "Table name", round(((data_length)/1024/1024),2) "Data size", round(((index_length)/1024/1024)...
1
vote
1answer
1k views

What's the difference between Object.bsonsize and avgObjSize returned by db.collection.stats?

In my collection, my documents seem to be relatively similar. I need to know how much storage I'll need in my production server to store my documents, that's why I queried : db.collectionName.stats() ...
1
vote
2answers
696 views

Sizing MySQL Database Servers for Drupal

What are some guidelines to follow when it comes to sizing MySQL Servers? CPUs, RAM, Disk Space, Clock Speeds, etc? We're going to go with either the community edition or the enterprise edition, and ...
1
vote
2answers
206 views

fixed length table

I only have ever used mysql and storing data on .txt files. Currently I'm working with tick data (I have node.js on my server). My custom setup so far stores a fixed amount of tick data as comma ...
1
vote
1answer
110 views

Can the number of tables and functions affect performance? [closed]

I have some big database with hundreds of functions and tables. They also have a lot of sequences, custom types and some views and triggers. There is a point when the quantity of objects will be a ...
1
vote
1answer
70 views

How big is my oracle database?

I need to determine the total size of an oracle database. Ideas on improving the following query? SELECT 'DataFiles: ' AS TYPE, SUM (bytes / 1024 / 1024) AS MB FROM dba_data_files UNION SELECT '...
1
vote
1answer
53 views

MySQL Database Instance size

We found 3 different size of a MySQL Database Instance as follows: Mysqldump output Data directory size (even if we exclude size of bin-logs,error-logs) SUM (data_length + index_length ) ...
1
vote
1answer
264 views

Size of DB files

I am trying to optimize some settings on a SQL Server that talks to inhouse programs. I have read to size all DB files the same. I have a server with a 20GB data file, with the other 9 files being ...
1
vote
1answer
259 views

MySQL row length is almost the triple of what I expect

I shamelessly took title and content from this question and adapted it to my similar yet different problem: This is the table I have: CREATE TABLE `test` ( `field1` MEDIUMINT(8) UNSIGNED NOT ...
1
vote
0answers
31 views

SQL Server 2014 Express database size limitation exceeded, suddenly cannot be exceeded anymore?

I have a database in SQL Server 2012 Express. I inserted 14 million rows to test index performance and everything was working fine. The database's PRIMARY file group was at over 21 GB. I had ...
1
vote
0answers
19 views

What is the most effective way to manage a community table with one customizable flag?

Fair warning I do not have dba training or anything of the like but I am managing a rather large web app database. I know the basics but I'm not sure how to handle this latest scenario. Setup I ...
1
vote
0answers
194 views

Multiple databases with medium tables or Single database with huge tables

I've developed a shop management software using Postgresql and JAVA. I would like to know which of the solutions below is the best one for my specific situation: Only one database with huge tables (...