pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Checking my HD space (noarchive) 2+ messages / 2 participants [nested] [flat]
* Checking my HD space (noarchive) @ 2003-03-03 16:36 Ries van Twisk <ries@jongert.nl> 2003-03-04 09:20 ` Re: Checking my HD space (noarchive) Richard Huxton <dev@archonet.com> 0 siblings, 1 reply; 2+ messages in thread From: Ries van Twisk @ 2003-03-03 16:36 UTC (permalink / raw) To: pgsql-sql 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? 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?? Ries ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Checking my HD space (noarchive) 2003-03-03 16:36 Checking my HD space (noarchive) Ries van Twisk <ries@jongert.nl> @ 2003-03-04 09:20 ` Richard Huxton <dev@archonet.com> 0 siblings, 0 replies; 2+ messages in thread From: Richard Huxton @ 2003-03-04 09:20 UTC (permalink / raw) To: Ries van Twisk <ries@jongert.nl>; 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-03-04 09:20 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-03-03 16:36 Checking my HD space (noarchive) Ries van Twisk <ries@jongert.nl> 2003-03-04 09:20 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox