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

Re: Significantly larger toast tables on 8.4?

From: "Alex Hunsaker" <badalex(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>, "Robert Haas" <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Significantly larger toast tables on 8.4?
Date: 2009-01-03 06:32:00
Message-ID: 34d269d40901022232j2d5f8abfo46ba799fe88ac622@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, Jan 2, 2009 at 18:46, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> It would be fairly easy, I think, to add some reloption fields that
> would let these parameters be controlled on a per-table level.

+1

Or something easier that just lets you use PGLZ_Strategy strategy_always_data.

ALTER TABLE SET STORAGE ALWAYS_COMPRESS;

Or is that way to stop gap?

> Per-column would be much more painful; do we really need that?

Obviously not for 8.4 this late in the game.

In response to

Responses

pgsql-hackers by date

Next:From: Simon RiggsDate: 2009-01-03 09:34:12
Subject: Re: Latest version of Hot Standby patch
Previous:From: Alex HunsakerDate: 2009-01-03 06:16:58
Subject: Re: Significantly larger toast tables on 8.4?

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