On Thu, Sep 4, 2008 at 1:39 PM, Ulrich <ulrich(dot)mierendorff(at)gmx(dot)net> 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
In response to
pgsql-performance by date
|Next:||From: Gregory Stark||Date: 2008-09-04 19:54:53|
|Subject: Re: limit clause breaks query planner?|
|Previous:||From: Ulrich||Date: 2008-09-04 19:39:08|
|Subject: Re: More shared_buffers instead of effective_cache_size?|