Re: [GENERAL] Checkpoint_segments optimal value

2014-07-17 Thread Potentialtech
# recover from partial page writes > #wal_buffers = 64kB # min 32kB > # (change requires restart) > #wal_writer_delay = 200ms # 1-1 milliseconds > > #commit_delay = 0 # range 0-10, in

Re: [GENERAL] Checkpoint_segments optimal value

2014-07-17 Thread Potentialtech
On Thu, 17 Jul 2014 14:06:28 -0400 Tom Lane wrote: > Potentialtech writes: > > If the warning isn't happening too often, I would try increasing it only a > > little and see if it helps. If it's not enough you can then increase it > > some > > more. Variou

Re: [GENERAL] Checkpoint_segments optimal value

2014-07-17 Thread Potentialtech
mistake where you set log_min_duration to 1s and only worry about queries that take longer than 1s? Because I've seen (on multiple occasions) where many 1000s of queries, each running less than 1s, are the actual cause of the problem. pgBadger is particularly helpful in tracking down situati