X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A2DF2476052 for ; Mon, 3 Mar 2003 11:52:11 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 42253-02 for ; Mon, 3 Mar 2003 11:52:09 -0500 (EST) Received: from sv003.int.jongert.nl (jongert.nl [194.109.59.87]) by postgresql.org (Postfix) with ESMTP id 69D3B47590C for ; Mon, 3 Mar 2003 11:37:29 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by sv003.int.jongert.nl (Postfix) with SMTP id D902E1A9; Mon, 3 Mar 2003 17:36:54 +0100 (CET) X-AV-Checked: Mon Mar 3 17:36:54 2003 jongert.nl Received: from IT001 (IT001.int.jongert.nl [10.0.0.241]) by sv003.int.jongert.nl (Postfix) with SMTP id 1FC6EF3 for ; Mon, 3 Mar 2003 17:36:52 +0100 (CET) From: "Ries van Twisk" To: Subject: Checking my HD space (noarchive) Date: Mon, 3 Mar 2003 17:36:50 +0100 Message-ID: <000201c2e1a3$180cdc10$f100000a@IT001> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/75 X-Sequence-Number: 12115 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