Re: Confirmation of bad query plan generated by 7.4 tree

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Shaun Thomas" <sthomas(at)leapfrogonline(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Confirmation of bad query plan generated by 7.4 tree
Date: 2006-06-13 21:07:24
Message-ID: 10557.1150232844@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Shaun Thomas" <sthomas(at)leapfrogonline(dot)com> writes:
> Simply changing:
> now() - interval '2 days'
> to
> '2006-06-11 15:30:00'
> generated a much more accurate set of estimates.

Yeah, 7.4 won't risk basing estimates on the results of non-immutable
functions. We relaxed that in 8.0 I believe.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-06-13 21:13:47 Re: Confirmation of bad query plan generated by 7.4
Previous Message Jim C. Nasby 2006-06-13 21:02:47 Re: OT - select + must have from - sql standard syntax?