database size

From: Shiby Thomas <sthomas(at)cise(dot)ufl(dot)edu>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: database size
Date: 1998-01-06 23:09:52
Message-ID: 199801062310.SAA28681@cise.ufl.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I created a table with two columns of type int, and loaded about 300 K records
in it. So, the total size of the table is approx. that of 600 K integers,
roughly 2.4 MB.
But, the file corresponding to the table in pgsql/data/base directory
has a size of 19 MB. I was wondering if I have done something wrong in
the installation or usage, or is it the normal behavior ?

Also, I was trying to execute the query:
select item as item, count(*) as cnt into table C_temp
from temp group by item;

Here, temp is the name of the table which contains the data and item is an
integer attribute. While doing the sort for the group by, the size of one of
the temporary pg_psort relation grows to about 314 MB. The size of the temp
table is as mentioned above. If someone tried similar queries, could you
please tell me if this is normal.
The above query did not finish even after 2 hours. I am executing it on a
Sun Sparc 5 running Sun OS 5.5.

Thanks
--shiby

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter T Mount 1998-01-06 23:13:23 Re: [HACKERS] I want to change libpq and libpgtcl for better handling of large query results
Previous Message Keith Parks 1998-01-06 21:11:53 Re: consttraints.source