Postgres Pro
Downloads
Home   >   mailing lists

Re: Use of subquery causes seq scan??? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Use of subquery causes seq scan???
Date
Msg-id 22627.1082498311@sss.pgh.pa.us
Whole thread Raw
In response to Use of subquery causes seq scan???  ("Chris Hoover" <revoohc@sermonaudio.com>)
List pgsql-performance
Tree view 
"Chris Hoover" <revoohc@sermonaudio.com> writes:
> Select *
> from table a
> where inv_num in (select inv_num from table b where ....)

> I'm running 7.3.4 on RedHat EL 2.1.

IN (SELECT) constructs pretty well suck in PG releases before 7.4.
Update, or consult the FAQ about rewriting into an EXISTS form.

            regards, tom lane

pgsql-performance by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Wierd context-switching issue on Xeon
Next
From: "Anjan Dave"
Date:
Subject: Moving postgres to FC disks