Re: Compression in PG

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Shaul Dar <shauldar(at)gmail(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Compression in PG
Date: 2009-11-01 18:27:13
Message-ID: dcc563d10911011027x3567c63bi286473f4f121abff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Nov 1, 2009 at 9:53 AM, Shaul Dar <shauldar(at)gmail(dot)com> wrote:
> Guys,
>
> I am aware of the TOAST mechanism (actually complained about it in this
> forum...). The text fields I have are below the limits that trigger this
> mechanism, and also I may want to compress specific fields, not all of them.
> And also I have performance concerns as TOAST splits tables and can
> potentially cause a performance hit on queries.

Did you even read the link posted?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2009-11-02 04:24:47 Re: Compression in PG
Previous Message Adam Tauno Williams 2009-11-01 17:23:32 Re: Compression in PG