Postgres Pro
Downloads
Home   >   mailing lists

Re: Index Scan Backward - Mailing list pgsql-admin

From Tom Lane
Subject Re: Index Scan Backward
Date
Msg-id 25640.1043678361@sss.pgh.pa.us
Whole thread Raw
In response to Index Scan Backward  (Luca Fabbro <lfabbro@conecta.it>)
Responses Re: Index Scan Backward  (Luca Fabbro <lfabbro@conecta.it>)
List pgsql-admin
Tree view 
Luca Fabbro <lfabbro@conecta.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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cannot connect to the database (PG 7.3)
Next
From: Luca Fabbro
Date:
Subject: Re: Index Scan Backward