Skip site navigation (1) Skip section navigation (2)

Re: !!! Compress individual tables with postgres

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "Shabala Deshpande" <de(dot)shabala(at)gmail(dot)com>
Cc: "Joshua Tolley" <eggyknap(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: !!! Compress individual tables with postgres
Date: 2008-10-01 10:21:51
Message-ID: 264855a00810010321w656d4e0bt4569374708209b7d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Wed, Oct 1, 2008 at 4:32 AM, Shabala Deshpande <de(dot)shabala(at)gmail(dot)com> wrote:
> I have read this article. I think it deals with the compresion at the
> individual data field level. I am trying to find out a way for  compressing
> individual tables that are generated on daily basis. I dont think so TOAST
> will help for compressing  the whole single individual table. please suggest
> if you know any other alternative.

Short of some significant coding, I think your best bet is to buy some
disks.  This assumes that you have been vacuuming the database
regularly and that you are not suffering from index bloat.  You should
check those two things to make sure.  If you really think that you
data are compressible and want to do that (not that I recommend it),
you might look into using a column-based database.

Sean


> On 9/30/08, Joshua Tolley <eggyknap(at)gmail(dot)com> wrote:
>>
>> On Tue, Sep 30, 2008 at 3:12 AM, Shabala Deshpande <de(dot)shabala(at)gmail(dot)com>
>> wrote:
>> > I have very large databases that are in postgresql (200Gbs+) and
>> > individual
>> > tables that take up as huge space. I know that in mysql one can compress
>> > individual tables with isam-compression. I understand that postgresql
>> > compresses text automatically, is there anyway to compress my large
>> > database
>> > further?
>> > Isn't there any specific method to compress the tables?? or does
>> > postgres
>> > handle it on its own? cause I have a large nos of daily generated tables
>> > with footprint of each of the table to be quite big.. so i need to
>> > compress
>> > the individual tables.. please help.
>> > Thanks and Regards,
>> >
>> > Shabala Deshpande
>>
>> PostgreSQL might already be compressing your data. See
>> http://www.postgresql.org/docs/8.3/interactive/storage-toast.html
>>
>> - Josh / eggyknap
>
>

In response to

pgsql-novice by date

Next:From: Mark WimerDate: 2008-10-01 15:21:24
Subject: Re: absolute novice wanting knowledgeable opinion about front end
Previous:From: Shabala DeshpandeDate: 2008-10-01 08:32:56
Subject: Re: !!! Compress individual tables with postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group