From: Richard Huxton <dev@archonet.com>
To: Ries van Twisk <ries@jongert.nl>
To: pgsql-sql@postgresql.org
Subject: Re: Checking my HD space (noarchive)
Date: Tue, 4 Mar 2003 09:20:52 +0000
Message-ID: <200303040920.52946.dev@archonet.com> (raw)
In-Reply-To: <000201c2e1a3$180cdc10$f100000a@IT001>
References: <000201c2e1a3$180cdc10$f100000a@IT001>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, ries@jongert.nl
Subject: Re: Checking my HD space (noarchive)
In-Reply-To: <200303040920.52946.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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