On Sun, Jun 21, 2009 at 9:01 PM, Justin Graf<justin@emproshunts.com> wrote: > work_mem = 51024 # min 64, size in KB > > Thats allot memory dedicated to work mem if you have 30 connections open > this could eat up 1.5gigs pushing the data out of cache.
I thought work memory is max memory that can be allocated per connection for sorting, etc. I think it is not allocated when connection is opened, but only on 'if needed' basis.