Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 5A2AF6321E7 for ; Sun, 1 Nov 2009 11:46:39 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 29355-02 for ; Sun, 1 Nov 2009 15:46:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from shrek.krogh.cc (2605ds1-ynoe.0.fullrate.dk [90.184.12.24]) by mail.postgresql.org (Postfix) with ESMTP id C68D7633382 for ; Sun, 1 Nov 2009 11:45:24 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by shrek.krogh.cc (Postfix) with ESMTP id 947B51DA15A; Sun, 1 Nov 2009 16:45:20 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at shrek.krogh.cc Received: from shrek.krogh.cc ([127.0.0.1]) by localhost (shrek.krogh.cc [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 3ef7X62pj82c; Sun, 1 Nov 2009 16:45:16 +0100 (CET) Received: from [90.184.13.137] (unknown [90.184.13.137]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: jesper@krogh.cc) by shrek.krogh.cc (Postfix) with ESMTPSA id CA1741DA0E5; Sun, 1 Nov 2009 16:45:15 +0100 (CET) Message-ID: <4AEDAD1F.6050602@krogh.cc> Date: Sun, 01 Nov 2009 16:45:35 +0100 From: Jesper Krogh User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Shaul Dar , "pgsql-performance@postgresql.org" Subject: Re: Compression in PG References: <234efe30911010651k6cf3d398t9d61e560d57b52b7@mail.gmail.com> In-Reply-To: <234efe30911010651k6cf3d398t9d61e560d57b52b7@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.507 tagged_above=-10 required=5 tests=AWL=-0.767, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 200911/3 X-Sequence-Number: 36171 Shaul Dar wrote: > Hi, > > I have several long text fields in my DB that I would love to compress > (descriptions, URLs etc). Can you tell me what options exists in PG > (+pointers please), typical effect on space and run time? variable length text fields .. e.g TEXT will automatically be stored in a TOAST table and compressed. Search the manual for toast. -- Jesper