From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | "Ries van Twisk" <ries(at)jongert(dot)nl>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Checking my HD space (noarchive) |
Date: | 2003-03-04 09:20:52 |
Message-ID: | 200303040920.52946.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Monday 03 Mar 2003 4:36 pm, Ries van Twisk wrote:
> Hi All,
>
> My bare text table is in size around 6Mb while the footprint of my database
> on HD (using du) is around 24Mb (after a vacuum -f)
> I have normalized the tables on places where I could do it.
> For your reference it's a squid2.2 access.log textfile.
> How can I check witch tables/indexes takes up so much space?
Your database files have a name equal to the object's oid. So if you have a
table with oid=1234 look for a file named "1234". You can figure out oids
manually, but there's a tool "oid2name" in the contrib folder of the source
distribution which can help you.
A 3x increase over a raw text file isn't unexpected once you allow for
structure overheads, indexes etc.
> And I did understand that postgresql can compress text but it seems that
> this is not the default case.
> can anybody tell me somthing about it and/or point my to a url??
I think you're talking about TOAST - check the manuals and techdocs, there's a
section about it somewhere. It's automatic for large textfields, and was
originally developed to work around PG's old 8k rowsize limit.
HTH
--
Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Samoylov | 2003-03-04 10:54:40 | Re: Insert multiple Rows |
Previous Message | Juan Fernández | 2003-03-04 09:11:54 | SQL books |