Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: !!! Compress individual tables with postgres
- From: "Joshua Tolley" <eggyknap(at)gmail(dot)com>
- To: "Shabala Deshpande" <de(dot)shabala(at)gmail(dot)com>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: !!! Compress individual tables with postgres
- Date: Tue, 30 Sep 2008 10:58:13 -0600
- Message-id: <e7e0a2570809300958p6cfecf16g6be699c15d9f5033@mail.gmail.com> <text/plain>
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
- References:
- !!! Compress individual tables with postgres
- From: Shabala Deshpande
- !!! Compress individual tables with postgres
- Prev by Date: Re: plpgsql functions vs. embedded queries
- Next by Date: Re: absolute novice wanting knowledgeable opinion about front end
- Previous by thread: !!! Compress individual tables with postgres
- Indexes: