On Wed, Aug 11, 2010 at 12:51:36AM -0400, Greg Smith wrote: > Andres Freund wrote: > >The most prohibitively expensive part is the AtEOXact_Buffers > >check of running through all buffers and checking their pin count. > >And it makes $app's regression tests take thrice their time... > Have you tried reducing shared_buffers from the default the system > found by probing to make this overhead smaller? Yes. Its getting slower just as you make them bigger. Which is not surprising... Using a smaller value than the default is painfull again as well though...
Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
