| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Robin Ericsson <robin(dot)ericsson(at)profecta(dot)se> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: query problem |
| Date: | 2004-10-13 15:03:13 |
| Message-ID: | 14684.1097679793@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Robin Ericsson <robin(dot)ericsson(at)profecta(dot)se> writes:
> I sent this to general earlier but I was redirected to performance.
Actually, I think I suggested that you consult the pgsql-performance
archives, where this type of problem has been hashed out before.
See for instance this thread:
http://archives.postgresql.org/pgsql-performance/2004-07/msg00169.php
particularly
http://archives.postgresql.org/pgsql-performance/2004-07/msg00175.php
http://archives.postgresql.org/pgsql-performance/2004-07/msg00184.php
http://archives.postgresql.org/pgsql-performance/2004-07/msg00185.php
which show three different ways of getting the planner to do something
sane with an index range bound like "now() - interval".
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2004-10-13 15:11:29 | Re: [GENERAL] Reusable pl/pgsql samples ? |
| Previous Message | Jason Tesser | 2004-10-13 15:00:04 | converting database to unicode |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Browne | 2004-10-13 15:52:28 | Opteron vs RHAT |
| Previous Message | ken | 2004-10-13 14:37:43 | Re: query problem |