The tag has no wiki summary.

learn more… | top users | synonyms

9
votes
2answers
6k 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 ...
9
votes
3answers
1k 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? ...
6
votes
1answer
3k 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 ...
6
votes
1answer
504 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
1answer
3k 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 ...
4
votes
2answers
6k 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
5answers
11k 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 ...
4
votes
1answer
1k 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?
4
votes
2answers
2k 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 ...
4
votes
1answer
432 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 ...
4
votes
2answers
110 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 ...
3
votes
2answers
1k 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 ...
3
votes
1answer
792 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.
3
votes
1answer
93 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
1k 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
881 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?
2
votes
2answers
1k 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?
2
votes
2answers
643 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
654 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
437 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
2answers
3k 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 ...
2
votes
1answer
657 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, ...
2
votes
1answer
654 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
609 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
1answer
214 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
860 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 ...
1
vote
1answer
203 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 ...
1
vote
2answers
593 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
1answer
97 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
188 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
48 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 ...
0
votes
1answer
172 views

SQL Server Table keeps big after schema change

I have a table in SQL Server 2012 with 460.000 rows. This Table has the following Schema: We had an issue with our application so all 500.000 rows were created with Comments filled up with spaces. ...
0
votes
1answer
567 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?
0
votes
1answer
26 views

Database storage limit for open source PostgresSQL

I just started using PostgresSQL. When I installed SQL Server Express years back, you typically had a database storage limit if you didn't install the full version. I think I remember it being 4GB, ...
0
votes
1answer
71 views

Are databases only growing in size?

Databases use the file system to store the data. As far as I know it is not possible to delete a record from a random access file. So does that mean that when we do a DELETE FROM TABLE the size of the ...
0
votes
2answers
41 views

Minimizing database size (Many small tables)

Our database is interesting in that we have a large amount of tables that take up a correspondingly large amount of space, but when we do a MySQL dump of said database, it is surprisingly small. ...
0
votes
1answer
43 views

Where's my missing Sql Server Express 2005 Database space? Size and space available dont add up to 4G?

I recently deleted some data from a table that was not needed and growing to too big a size with this query which provided to me by a support tech... declare @mdate datetime set ...
0
votes
1answer
18 views

Preview the increment in a Mysql table size before running the ALTER TABLE ADD COLUMN statement

Is it possible to preview how much the table size will be incremented by an ALTER TABLE ADD COLUMN statement before running the statement in the database?
0
votes
0answers
20 views

Where's my missing Sql Server Express 2005 Database space? Size and space available dont add up to SQL express size 4G? [duplicate]

I recently deleted some data from a table that was not needed and growing to too big a size with this query which provided to me by a support tech... declare @mdate datetime set @mdate='04/04/2014' ...
0
votes
0answers
25 views

Understanding SQLite filesize, size “always” 1.471.488 bytes

We store some Data in a zipped SQLite file. Basically it's 7 tables, 6 of fixed size and one table varies. The table has only 3 fields, which contain the date and 2 small integers. Example: ...
0
votes
0answers
62 views

How large should a database table grow?

I have been experiencing some very slow queries for a specific table. This table grows daily. I ran the pg_relation_size function, which gives the size of a table in the database: mydb=# select ...
0
votes
0answers
29 views

How to avoid hitting the memory ceiling with temporary table?

I running a MySql DB at a webhosting company. The size limit of a schema/DB is set to 100Mb. I'm using temporary tables in my query like: CREATE TEMPORARY TABLE t_foo SELECT * FROM Foo INNER JOIN ...