On Sat, Apr 13, 2013 at 9:01 PM, Rodrigo Barboza <rodrigombufrj@xxxxxxxxx> wrote: > Would it help if I changed the checkpoint_completion_target to something close to 0.7 (mine is the default 0.5) or raise the checkpoint_segments (it is 32 now)? That depends. What are your access patterns like? Do you have 1 or 2 writers, a dozen, a hundred? If you've got hundreds of active writers then look at pooling an also commit_siblings and commit_delay. -- To understand recursion, one must first understand recursion. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
