--- Greg Stark <gsstark(at)mit(dot)edu> wrote:
> Mr Pink <mr_pink_is_the_only_pro(at)yahoo(dot)com> writes:
> > AFAIK postgres doesn't peek at values used in a query when optimizing
> Of course it does.
But not ones returned by a function such as now(), or when you use bind variables, as Tom aptly
That's what I meant by 'peek'. Interestingly enough Oracle does that, it's inline with their
policy of recommending the use of bind variables. Perhaps postgres could use such a feature some
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2004-08-30 02:23:56|
|Subject: Re: Why does a simple query not use an obvious index? |
|Previous:||From: Russell Smith||Date: 2004-08-29 22:31:30|
|Subject: Re: Query performance problem in 8.0.0beta1|