July 14th, 2012, 06:55 AM
Join Date: Jul 2012
Time spent in forums: 31 m 12 sec
Reputation Power: 0
Huge harddisk space overhead
I am new to PostgreSQL and I am having a problem where I could not find a post or article explaining the following problem:
I wanna store the content of an ascii file (numbers 1 to 30.000.000) in a postgre table.
The table has one coulmn defined as integer
I use a copy statement.
Afterwards the table is filled with the correct content.
I have no indexes but the disk space even after VACUUM is 1,3 GB.
Of course a database usually has a small overhead
but why is it 4 times the size of the ascii file.
What can I do to make the table smaller??
Thank you in advance