Re: The Last Optimization

> I did already a some optimization optimization :
>
>     max_connections = 64
>     shared_buffers = 32000
>     sort_mem = 64336
>     fsync = false

Ouch... 64MB of sort_mem? It'll only take 32 sort operations to exhaust your
memory... actually much less since your 2GB isn't likely to be used
exclusively for sorting.

I would start by pushing sort_mem back to 8192 (you might be able to get
away with 16384, but I wouldn't go any higher). Anything else, we'll need to
know what you're doing, schema, queries, explain analyze, etc.

Greg