Re: Significantly larger toast tables on 8.4?

Alex Hunsaker <badalex@gmail.com>

From: "Alex Hunsaker" <badalex@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Gregory Stark" <stark@enterprisedb.com>, "Stephen R. van den Berg" <srb@cuci.nl>, "Robert Haas" <robertmhaas@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2009-01-03T06:32:00Z
Lists: pgsql-hackers
On Fri, Jan 2, 2009 at 18:46, Tom Lane <tgl@sss.pgh.pa.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.