"hubert depesz lubaczewski" wrote: > On 19 Dec 2006 07:01:41 -0800, Angva <angvaw@xxxxxxxxx> wrote: > > > > shared_buffers = 57344 > > work_mem = 200000 > > maintenance_work_mem = 524288 > > > > work_mem seems to be high. what is you max_connections setting? max_connections = 100 However we never come even close to 100 connections at once on this database. Rarely, if ever, do we even reach 10. But I am unsure why work_mem is set to 200000. I personally tuned shared_buffers and maintenance_work_mem for performance, but I just don't know why work_mem is what it is. So, I'll gladly accept any suggestions about this setting. :) Thanks a lot, Mark
