Re: poor performance of subquery in psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "John Liu" <johnl(at)emrx(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: poor performance of subquery in psql
Date: 2003-01-29 07:33:01
Message-ID: 20619.1043825581@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

"John Liu" <johnl(at)emrx(dot)com> writes:
> why psql subquery is not smarter enough to use
> indexes if obviously?

IN is smarter as of CVS tip.

regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2003-01-29 15:24:46 pgsql-server/src/backend/executor spi.c
Previous Message Bruce Momjian - CVS 2003-01-29 03:41:56 pgsql-server/src/tools RELEASE_CHANGES

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-01-29 07:37:31 Re: Strange Prepare bug
Previous Message Tom Lane 2003-01-29 07:26:14 Re: Can we revisit the thought of PostgreSQL 7.2.4?