X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C47F8D9B00 for ; Mon, 10 Oct 2005 14:48:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43493-03 for ; Mon, 10 Oct 2005 17:48:54 +0000 (GMT) Received: from ucsns.ucs.co.za (ucsns.ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id 84BA9D79CF for ; Mon, 10 Oct 2005 14:48:54 -0300 (ADT) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 3FBBE2BD43; Mon, 10 Oct 2005 19:48:53 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id C3AF0D9DAA; Mon, 10 Oct 2005 19:48:53 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with ESMTP id 995BC977D8; Mon, 10 Oct 2005 19:48:53 +0200 (SAST) Date: Mon, 10 Oct 2005 19:48:53 +0200 From: Stef To: "Jim C. Nasby" Cc: pgsql-admin Subject: Re: Compression of text columns Message-ID: <20051010194853.49dd6355@svb.ucs.co.za> In-Reply-To: <20051010163132.GL39569@pervasive.com> References: <20051010141839.742f6301@svb.ucs.co.za> <20051010163132.GL39569@pervasive.com> X-Mailer: Sylpheed-Claws 1.9.6cvs1 (GTK+ 2.6.10; i486-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YEWH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@ X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.127 required=5 tests=[AWL=0.127] X-Spam-Level: X-Archive-Number: 200510/119 X-Sequence-Number: 19191 Jim C. Nasby mentioned : => Are you seeing much gain using ztext over using EXTENDED? When storage is defined external, there is a visible gain, but not really significant enough to make me want to use it. And I had instances where not all the rows would uncompress again afterwards. I want to try and get the bzip2 compression working, and see if that does anything for me. But at this stage, I think it's as compressed as I will be able to get it. I'm not getting the best results, because a lot of the data rows don't contain enough data to compress properly, and I think with ztext the column sizes sometimes end up bigger than they were to start off with. Kind Regards Stefan