Checking my HD space (noarchive) - Mailing list pgsql-sql

From Ries van Twisk
Subject Checking my HD space (noarchive)
Date
Msg-id 000201c2e1a3$180cdc10$f100000a@IT001
Whole thread Raw
Responses Re: Checking my HD space (noarchive)  (Richard Huxton <dev@archonet.com>)
List 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



pgsql-sql by date:

Previous
From: "Victor Yegorov"
Date:
Subject: Re: Querying Hierarchical Data
Next
From: Achilleus Mantzios
Date:
Subject: Re: Querying Hierarchical Data