Postgres Pro
Downloads
Home   >   mailing lists

Re: Confirmation of bad query plan generated by 7.4 tree - Mailing list pgsql-performance

From Tom Lane
Subject Re: Confirmation of bad query plan generated by 7.4 tree
Date
Msg-id 10557.1150232844@sss.pgh.pa.us
Whole thread Raw
In response to Re: Confirmation of bad query plan generated by 7.4  ("Shaun Thomas" <sthomas@leapfrogonline.com>)
List pgsql-performance
Tree view 
"Shaun Thomas" <sthomas@leapfrogonline.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

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: OT - select + must have from - sql standard syntax?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Which processor runs better for Postgresql?