On Thu, May 24, 2012 at 2:24 PM, Merlin Moncure <mmonc...@gmail.com> wrote: >> As you can see, raw performance isn't much worse with the larger data >> sets, but scalability at high connection counts is severely degraded >> once the working set no longer fits in shared_buffers. > > Hm, wouldn't the BufFreelistLock issue be ameliorated if > StrategyGetBuffer could reserve multiple buffers so that you'd draw > down your local list and only then go back to the global pool? (easier > said than done obviously).
hm, looking at the code some more, it looks like the whole point of the strategy system is to do that. ISTM bulk insert type queries would be good candidates for a buffer strategy somehow? merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
