Re: Significantly larger toast tables on 8.4? - Mailing list pgsql-hackers

From Philip Warner
Subject Re: Significantly larger toast tables on 8.4?
Date
Msg-id 4960314B.2020502@rhyme.com.au
Whole thread Raw
In response to Re: Significantly larger toast tables on 8.4?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Significantly larger toast tables on 8.4?
List pgsql-hackers
Tom Lane 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.
> Per-column would be much more painful; do we really need that?
>   

Another +1 on the per-table setting. Or a config file setting to disable
this for the instance.

We have a 200GB DB that is mostly large text (>1MB) that is not searched
with substr. If we see a blowout in size of even 3x, we will not be able
to upgrade due to disk space limitations (at least without paying for a
lot of disks on mirror servers and hot-standy servers).




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Time to finalize patches for 8.4 beta
Next
From: Alvaro Herrera
Date:
Subject: Re: generic reloptions improvement