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.
On Tue, Sep 30, 2008 at 3:12 AM, Shabala Deshpande <de.shabala@gmail.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