#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Posts
    2
    Rep Power
    0

    Huge harddisk space overhead


    Dear all,

    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

    Neo
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Posts
    2
    Rep Power
    0
    No one any idea?

    Is this the wrong place to post?
    Did I miss anything?

IMN logo majestic logo threadwatch logo seochat tools logo