On Fri, 13 Jun 2003 20:45:06 +0200, Ryszard Lach <siaco(at)autograf(dot)pl>
>I have a problem with performance after upgrading from 7.2 to 7.3.
and then re-run your query. If it is still slow, post the new EXPLAIN
ANALYSE output here.
In response to
pgsql-performance by date
|Next:||From: Tomaz Borstnar||Date: 2003-06-15 22:37:30|
|Subject: Re: any way to use indexscan to get last X values|
|Previous:||From: Tom Lane||Date: 2003-06-15 16:53:10|
|Subject: Re: any way to use indexscan to get last X values with "order by Y limit X" clause? |