Checking my HD space (noarchive)

From: "Ries van Twisk" <ries(at)jongert(dot)nl>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Checking my HD space (noarchive)
Date: 2003-03-03 16:36:50
Message-ID: 000201c2e1a3$180cdc10$f100000a@IT001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Saint X 2003-03-03 16:38:20 Insert multiple Rows
Previous Message Victor Yegorov 2003-03-03 16:34:36 Re: Querying Hierarchical Data