Re: First query is slow, subsequent queries fast - Mailing list pgsql-performance

From Stephan Vollmer
Subject Re: First query is slow, subsequent queries fast
Date
Msg-id 43972B01.3070709@gmx.de
Whole thread Raw
In response to Re: First query is slow, subsequent queries fast  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: High context switches occurring
Next
From: Richard Huxton
Date:
Subject: Re: Join the same row