Re: possible wrong query plan on pg 8.3.5, - Mailing list pgsql-performance

From Віталій Тимчишин
Subject Re: possible wrong query plan on pg 8.3.5,
Date
Msg-id 331e40660909142332v570cc686hb2c75fd974b8d69e@mail.gmail.com
Whole thread Raw
In response to Re: possible wrong query plan on pg 8.3.5,  (zz_11@mail.bg)
Responses Re: possible wrong query plan on pg 8.3.5,
List pgsql-performance
May be you have very bad disk access times (e.g. slow random access)? In this case everything should be OK while data in cache and awful, when not.
Could you check disk IO speed && IO wait while doing slow & fast query.

BTW: In this case, increasing shared buffers may help. At least this will prevent other applications & AFAIK sequence scans to move your index data from cache.

Best regards, Vitalii Tymchyshyn

pgsql-performance by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: How to post Performance Questions
Next
From: Andrzej Zawadzki
Date:
Subject: Re: CLUSTER and a problem