Re: un-understood index performance behaviour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Emiliano Leporati" <emiliano(dot)leporati(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: un-understood index performance behaviour
Date: 2008-07-01 14:18:20
Message-ID: 3340.1214921900@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Emiliano Leporati" <emiliano(dot)leporati(at)gmail(dot)com> writes:
> can anybody explain me why this happens ? and if i should try different
> indexes ?

Showing EXPLAIN ANALYE output would probably make things a lot clearer.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-07-01 15:03:22 Re: Inact_dirty is increasing continuously and causing the system to hang.
Previous Message Scott Marlowe 2008-07-01 14:17:17 Re: un-understood index performance behaviour