Обсуждение: !!! Compress individual tables with postgres
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.
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
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 PostgreSQL might already be compressing your data. See http://www.postgresql.org/docs/8.3/interactive/storage-toast.html - Josh / eggyknap
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.
Thanks and Regards,
Shabala
On 9/30/08, Joshua Tolley <eggyknap@gmail.com> wrote:
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
PostgreSQL might already be compressing your data. See
http://www.postgresql.org/docs/8.3/interactive/storage-toast.html
- Josh / eggyknap
On Wed, Oct 1, 2008 at 4:32 AM, Shabala Deshpande <de.shabala@gmail.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@gmail.com> wrote: >> >> 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 >> >> PostgreSQL might already be compressing your data. See >> http://www.postgresql.org/docs/8.3/interactive/storage-toast.html >> >> - Josh / eggyknap > >