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

!!! Compress individual tables with postgres

From: "Shabala Deshpande" <de(dot)shabala(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: !!! Compress individual tables with postgres
Date: 2008-09-30 09:12:08
Message-ID: 16b7e2640809300212q613b7668h1762a6e45ceeae1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Wright, GeorgeDate: 2008-09-30 13:25:33
Subject: Re: plpgsql functions vs. embedded queries
Previous:From: Tom LaneDate: 2008-09-29 23:07:11
Subject: Re: plpgsql functions vs. embedded queries

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