Gregory Stark <[EMAIL PROTECTED]> writes:
> A lot of the recently proposed changes don't really fit in the
> "optimizations" category very well at all. I think of them more as
> "avoiding pitfalls".
Well, we can't put a major amount of complexity into the system for
each possible "pitfall".
> This one is similar, if you keep a bunch of static data attached to
> some small dynamic data your WAL and table bloats.
Actually, PG does extremely well on that in the situation where the
static data is *really* wide, ie, wide enough to be toasted out-of-line.
Simon's proposal will only help for an intermediate range of situations
where the row is wide but not very wide.
It strikes me that a more useful solution might come from the recent
discussions about offering more user control of per-column toasting
decisions. Or maybe we just need to revisit the default toast
thresholds --- AFAIR there has never been any significant study of
the particular values that Jan picked originally.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
