Re: !!! Compress individual tables with postgres
| От | Shabala Deshpande |
|---|---|
| Тема | Re: !!! Compress individual tables with postgres |
| Дата | |
| Msg-id | 16b7e2640810010132j7bec27c2xad221397b8b70984@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: !!! Compress individual tables with postgres ("Joshua Tolley" <eggyknap@gmail.com>) |
| Ответы |
Re: !!! Compress individual tables with postgres
|
| Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: