On Fri, Sep 9, 2011 at 5:38 PM, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx> wrote: > This is getting back to that issue of using only enough processes at > one time to keep all the bottleneck resources fully utilized. Some > people tend to assuem that if they throw a few more concurrent > processes into the mix, it'll all get done sooner. There are a > great many benchmarks which show otherwise. On the other hand, in order to benefit from synchro scans and stuff like that, one has to increase concurrency beyond what is normally considered optimal. I have an application that really benefits from synchro scans, but from time to time, when planets are aligned wrong, the extra concurrency does hurt. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
