July 14th, 2012, 06:55 AM
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
July 18th, 2012, 02:02 PM
No one any idea?
Is this the wrong place to post?
Did I miss anything?