Re: possible wrong query plan on pg 8.3.5,

From: Віталій Тимчишин <tivv00(at)gmail(dot)com>
To: zz_11(at)mail(dot)bg
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: possible wrong query plan on pg 8.3.5,
Date: 2009-09-15 06:32:26
Message-ID: 331e40660909142332v570cc686hb2c75fd974b8d69e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrzej Zawadzki 2009-09-15 07:36:38 Re: CLUSTER and a problem
Previous Message Michael Glaesemann 2009-09-14 23:19:03 Re: How to post Performance Questions