| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Edmund Dengler <edmundd(at)eSentire(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance of a query |
| Date: | 2003-06-12 01:40:08 |
| Message-ID: | 20030612014008.GA20990@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jun 11, 2003 at 21:13:52 -0400,
Edmund Dengler <edmundd(at)eSentire(dot)com> wrote:
> Tried the query. Looks like this suffers the same fate as now(): the
> planner does not deal with this as a pseudo constant, so therefore the
> estimator over-estimates the number of possible rows, and thereby chooses
> the wrong operator (a "merge join") to apply.
I tried some more variations and couldn't get it to use an index.
It seems odd that a timestamp without time zone is getting treated
as not constant (presumably because the timezone could change).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dima Tkach | 2003-06-12 01:42:24 | Re: need a method to ping a running database |
| Previous Message | Ardell Dzaky | 2003-06-12 01:24:10 | test - pls ignore |