On Nov 19, 2007, at 9:23 AM, Tom Lane wrote:
> Decibel! <decibel(at)decibel(dot)org> writes:
>> FWIW, 20k rows isn't all that big, so I'm assuming that the
>> descriptions make the table very wide. Unless those descriptions are
>> what's being updated frequently, I suggest you put those in a
>> separate table (vertical partitioning). That will make the main table
>> much easier to vacuum, as well as reducing the impact of the high
>> churn rate.
> Uh, you do realize that the TOAST mechanism does that pretty much
Only if the row exceeds 2k, which for a lot of applications is huge.
This is exactly why I wish toast limits were configurable on a per-
table basis (I know there were changes here for 8.3, but IIRC it was
only for toast chunk size).
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
In response to
pgsql-performance by date
|Next:||From: Decibel!||Date: 2007-12-06 00:07:58|
|Subject: Re: TB-sized databases|
|Previous:||From: Scott Marlowe||Date: 2007-12-05 22:20:16|
|Subject: Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005)|