DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=QJlm3owK+sqecM+RW10EPRFzLdnf7SpNZN/RhjgUL4Q70Ac2eWSMQYrkvfivud5eik
	B0PCBJs+99IEoatIZ4iDujnqFLhnLNO99cbbrPnp0iWYW7wPP8bmDPjNaL3wrQz0dC+K
	7mnuHoEYXnKEpqL6UeSFHVMD2i/jKCEY5AGg4=
Message-ID: <dcc563d10809041249w5ff1ed59pd8964da5e3d605e7@mail.gmail.com>
Date: Thu, 4 Sep 2008 13:49:05 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: Ulrich <ulrich.mierendorff@gmx.net>
Subject: Re: More shared_buffers instead of effective_cache_size?
Cc: pgsql-performance@postgresql.org
In-Reply-To: <48C0395C.4000806@gmx.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <48C035E2.3070407@gmx.net>
	<dcc563d10809041230h751129c4o93d68c083b8c72e9@mail.gmail.com>
	<48C0395C.4000806@gmx.net>

On Thu, Sep 4, 2008 at 1:39 PM, Ulrich <ulrich.mierendorff@gmx.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
effect.