Hi, > That is on a Dual 1Ghz P3, 1gb ram [..]
> sort_mem = 65536 # min 64, size in KB Depending on the usage of your database this is a very high value. Every sort (including internal sort for merge joins p.e.) is allowed to take 64 MB. If one query needs three sorts, that query is allowed to take 192 MB memory. It's much cheaper to let the database use temporary files for sorting than to risk swapping. Thomas -- http://www.tmueller.com for pgp key (95702B3B)