Postgres Pro
Downloads
Home   >   mailing lists

Re: poor performance of subquery in psql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: poor performance of subquery in psql
Date
Msg-id 20619.1043825581@sss.pgh.pa.us
Whole thread Raw
In response to poor performance of subquery in psql  ("John Liu" <johnl@emrx.com>)
List pgsql-hackers
Tree view 
"John Liu" <johnl@emrx.com> writes:
> why psql subquery is not smarter enough to use
> indexes if obviously?

IN is smarter as of CVS tip.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Specifying Rowtypes
Next
From: "Christopher Kings-Lynne"
Date:
Subject: FW: [GENERAL] problems with dropped columns