Laurent Laborde <kerdezixe(at)gmail(dot)com> wrote:
> (iostat show a 5~25MB/s bandwidth at 100%util instead of 2~5MB/s at
Any numbers for overall benefit at the application level?
> So... now i'm not sure anymore about lowering the tuple per page
> om 4 to 8.
> Doing that would mean more data in TOAST table ...
Yeah, I've been skeptical that it would be a good thing for your
situation unless the lower target only applied to more aggressive
compression, not out-of-line storage.
If you can wait for a week or two, I can give you a "proof of concept"
patch to use separate targets for compression and out-of-line storage.
It would be interesting to see how much that helps when combined with
your more aggressive compression configuration.
In response to
pgsql-hackers by date
|Next:||From: David E. Wheeler||Date: 2009-07-23 15:02:50|
|Subject: Re: Extension Facility|
|Previous:||From: Tom Lane||Date: 2009-07-23 14:39:51|
|Subject: Re: Upgrading our minimum required flex version for 8.5 |