"Jim 'Decibel!' Nasby" <jnasby@xxxxxxxxxxxxxx> writes: > On Nov 10, 2008, at 1:31 PM, Tom Lane wrote: >> On my machine this runs about twice as fast as the original view. > Am I missing some magic? I'm still getting the subquery scan. Hmm, I'm getting a core dump :-( ... this seems to be busted in HEAD. 8.3 gets it right though. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance