Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id BA07D632636
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun,  1 Nov 2009 10:52:04 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 18020-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun,  1 Nov 2009 14:51:56 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com
	[209.85.218.213])
	by mail.postgresql.org (Postfix) with ESMTP id A89AF63215D
	for <pgsql-performance@postgresql.org>;
	Sun,  1 Nov 2009 10:51:56 -0400 (AST)
Received: by bwz5 with SMTP id 5so5444846bwz.3
	for <pgsql-performance@postgresql.org>;
	Sun, 01 Nov 2009 06:51:54 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=nqndaW0riYZBcvdctMAHRnh0iQsGZxSV1wQcaXXGjto=;
	b=wwmBdBH/xWNhKwjX3a7jLaH9Fr+OIDz98u14HVtydlFILErFACZ/tRDDLZtKE63W8k
	xAgUlHkfp9QDvevLXqHAbv+i8YokWqX15fqKymitudwIlzfZKP5uojoTapU8hOdooFC8
	cEBGN5wmZviIMJ7A4e8Hw3d0b6PhboeByMpiw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=Ac4kxby9kSsaXWODY2v8wWUHuxv44TzkSw72Pmo1vnE4tuv82MwznWA3v3kHr8SV1m
	ZwpYD1XgwDO4WxSOXARc38V7HA0DeGEr45LN6r6yCvRZGp13hfBgO/peXiVpp48SUCHT
	93JzBuqvS8sl3mfV4WRmANXmFBqhpdPvE+CWs=
MIME-Version: 1.0
Received: by 10.204.15.22 with SMTP id i22mr3070899bka.13.1257087114080; Sun,
	01 Nov 2009 06:51:54 -0800 (PST)
Date: Sun, 1 Nov 2009 16:51:53 +0200
Message-ID: <234efe30911010651k6cf3d398t9d61e560d57b52b7@mail.gmail.com>
Subject: Compression in PG
From: Shaul Dar <shauldar@gmail.com>
To: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=00032555bd46e2f306047750660d
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.109 tagged_above=-10 required=5
	tests=BAYES_05=-1.11, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200911/1
X-Sequence-Number: 36169

--00032555bd46e2f306047750660d
Content-Type: text/plain; charset=ISO-8859-1

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?

Thanks,

-- Shaul

--00032555bd46e2f306047750660d
Content-Type: text/html; charset=ISO-8859-1

<div dir="ltr">Hi,<br><br>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?<br>
<br>Thanks,<br><br clear="all">-- Shaul<br>
</div>

--00032555bd46e2f306047750660d--