On Thu, Sep 4, 2008 at 1:39 PM, Ulrich <[EMAIL PROTECTED]> wrote: > Scott Marlowe wrote: >> >> Stop using a virtual server? > > That is not possible...
Sorry shoulda had a smiley face at the end of that. :) <-- there >> I wouldn't set shared_buffers that high >> just because things like vacuum and sorts need memory too > > Okay, I understand that vacuum uses memory, but I thought sorts are done in > work_mem? I am only sorting the result of one query which will never return > more than 500 rows. You can probably play with larger shared memory, but I'm betting that the fact that you're running under a VM is gonna weigh eveything down a great deal, to the point that you're tuning is going to have minimal effect. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
