Re: [PERFORM] System overload / context switching / oom, 8.3

2010-02-03 Thread Rob Lemley
Andy Colson wrote: > work_mem = 32MB > maintenance_work_mem = 64MB if you have lots and lots of connections, you might need to cut these down? definitely, work_mem is the main focus. If I understand correctly, th 64MB maintenance_work_mem is per vacuum task, and on this system there are 3

Re: [PERFORM] commit so slow program looks frozen

2006-10-31 Thread Rob Lemley
Merlin Moncure wrote: > On 10/28/06, Simon Riggs <[EMAIL PROTECTED]> wrote: >> On Thu, 2006-10-26 at 11:06 -0400, Merlin Moncure wrote: >> > On 10/26/06, Carlo Stonebanks <[EMAIL PROTECTED]> wrote: >> > > This is pretty interesting - where can I read more on this? >> Windows isn't >> > > actually h