Re: First query is slow, subsequent queries fast

From: Stephan Vollmer <svollmer(at)gmx(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: First query is slow, subsequent queries fast
Date: 2005-12-07 18:33:37
Message-ID: 43972B01.3070709@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Edison Azzi 2005-12-07 18:45:12 Re: Join the same row
Previous Message Scott Marlowe 2005-12-07 16:24:33 Re: High context switches occurring