On Sun, 20 Aug 2000, Franz J Fortuny wrote:
>
>
>
> "What version of Postgres are you using, and what does
> EXPLAIN show
> as the query plan for this query? How many tableY rows
> is the sub-
> query likely to produce, and how many matches do you
> expect to get
> from tableX?"
>
> Version: postgresql-7.0.2-2.i386.rpm
> Explain: Scan table, scan table. (Plus the costs, etc.)
use cut-n-paste please, and send us the results of the EXPLAIN ... stuff
like the cost estimates and whatnot tell us *so* much ...