From: Stephan Vollmer <svollmer@gmx.de>
To: pgsql-performance@postgresql.org
Subject: Re: First query is slow, subsequent queries fast
Date: Wed, 07 Dec 2005 19:33:37 +0100
Message-ID: <43972B01.3070709@gmx.de> (raw)
In-Reply-To: <Pine.GSO.4.63.0512071351390.13553@ra.sai.msu.su>
References: <4396BD7B.1050708@gmx.de>
<Pine.GSO.4.63.0512071351390.13553@ra.sai.msu.su>
Hi Oleg, thanks for your quick reply!
Oleg Bartunov wrote:
> you cache is too low :) Try to increase shared_buffers, for example,
> for 2Gb I'd set it to 100,000
Ok, I set shared_buffers to 100000 and indeed it makes a big
difference. Other queries than the ones I mentioned are faster, too.
Thanks very much for your help,
- Stephan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: svollmer@gmx.de
Subject: Re: First query is slow, subsequent queries fast
In-Reply-To: <43972B01.3070709@gmx.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox