Re: Index Scan Backward

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luca Fabbro <lfabbro(at)conecta(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Index Scan Backward
Date: 2003-01-27 14:39:21
Message-ID: 25640.1043678361@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Luca Fabbro <lfabbro(at)conecta(dot)it> writes:
> It seems that the problem is in the Backward scan of the index :(

It looks like a pretty reasonable plan to me. Could we see the output
of EXPLAIN ANALYZE, not just EXPLAIN?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Luca Fabbro 2003-01-27 14:52:03 Re: Index Scan Backward
Previous Message Tom Lane 2003-01-27 14:10:50 Re: Cannot connect to the database (PG 7.3)