X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D3156D6DF5 for ; Tue, 11 Oct 2005 05:03:06 -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 60974-05 for ; Tue, 11 Oct 2005 08:03:04 +0000 (GMT) Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by svr1.postgresql.org (Postfix) with ESMTP id 01289D6DB0 for ; Tue, 11 Oct 2005 05:03:04 -0300 (ADT) Received: from 192.168.0.3 (unknown [84.12.188.233]) by smtp.nildram.co.uk (Postfix) with ESMTP id A881A254B75; Tue, 11 Oct 2005 09:03:04 +0100 (BST) Subject: Re: Compression of text columns From: Simon Riggs To: Stef Cc: Tino Wildenhain , pgsql-performance@postgresql.org In-Reply-To: <20051010145700.586dc488@svb.ucs.co.za> References: <20051010141721.0bebbaa7@svb.ucs.co.za> <434A5E22.9040500@wildenhain.de> <20051010145700.586dc488@svb.ucs.co.za> Content-Type: text/plain Organization: 2nd Quadrant Date: Tue, 11 Oct 2005 09:02:57 +0100 Message-Id: <1129017777.8300.354.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.047 required=5 tests=[AWL=-0.003, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/184 X-Sequence-Number: 14952 On Mon, 2005-10-10 at 14:57 +0200, Stef wrote: > Is there any way to achieve better compression? You can use XML schema aware compression techniques, but PostgreSQL doesn't know about those. You have to do it yourself, or translate the XML into an infoset-preserving form that will still allow XPath and friends. Best Regards, Simon Riggs