Re: Oddity with view (now with test case)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim 'Decibel!' Nasby" <jnasby(at)cashnetusa(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, postgresql performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Oddity with view (now with test case)
Date: 2008-11-11 03:20:09
Message-ID: 9474.1226373609@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jim 'Decibel!' Nasby" <jnasby(at)cashnetusa(dot)com> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2008-11-11 14:52:50 Re: Create and drop temp table in 8.3.4
Previous Message Jim 'Decibel!' Nasby 2008-11-10 21:06:36 Re: Oddity with view (now with test case)