Re: Compression in PG

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Shaul Dar <shauldar(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Compression in PG
Date: 2009-11-01 14:56:17
Message-ID: 162867790911010656m37b315dbp41761a014745b9e4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2009/11/1 Shaul Dar <shauldar(at)gmail(dot)com>:
> 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?

Hello

You can do nothing. PostgreSQL compresses data automatically

http://www.postgresql.org/docs/8.4/interactive/storage-toast.html

Regards
Pavel Stehule
>
> Thanks,
>
> -- Shaul
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jesper Krogh 2009-11-01 15:45:35 Re: Compression in PG
Previous Message Shaul Dar 2009-11-01 14:51:53 Compression in PG