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 10 and indeed it makes a big
difference. Other queries than the ones I mentioned are faster, too.
Tha
Stephan,
you cache is too low :) Try to increase shared_buffers, for example,
for 2Gb I'd set it to 100,000
On Wed, 7 Dec 2005, Stephan Vollmer wrote:
Hi everybody!
This is my first posting to this list and I'm quite a PostgreSQL
newbie. My question is:
The first time I execute a query, it i
Hi everybody!
This is my first posting to this list and I'm quite a PostgreSQL
newbie. My question is:
The first time I execute a query, it is very slow, but subsequent
queries are as fast as expected. I would be very glad if somebody
could explain why the first query is so slow and what I could