Laurent Laborde <kerdez...@gmail.com> wrote: > (iostat show a 5~25MB/s bandwidth at 100%util instead of 2~5MB/s at > 100%util). 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. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
