From: Ries van Twisk <ries@jongert.nl>
To: pgsql-sql@postgresql.org
Subject: Checking my HD space (noarchive)
Date: Mon, 3 Mar 2003 17:36:50 +0100
Message-ID: <000201c2e1a3$180cdc10$f100000a@IT001> (raw)
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
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: ries@jongert.nl
Subject: Re: Checking my HD space (noarchive)
In-Reply-To: <000201c2e1a3$180cdc10$f100000a@IT001>
* 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