The database-size tag has no wiki summary.
6
votes
3answers
329 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
334 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
...
4
votes
1answer
291 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 ...
3
votes
2answers
1k 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 ...
3
votes
2answers
370 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
2answers
518 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 ...
3
votes
1answer
219 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
383 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
1k 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 ...
2
votes
4answers
122 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 ...
2
votes
2answers
151 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 ...
2
votes
2answers
276 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
477 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
39 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?
2
votes
1answer
201 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
875 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 ...
2
votes
1answer
166 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
1answer
442 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
0answers
42 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
130 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
186 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
2answers
450 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
551 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
...
1
vote
1answer
127 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 ...
0
votes
1answer
110 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.
...
