| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, Mark <sendmailtomark(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: query for a time interval |
| Date: | 2005-12-23 15:22:55 |
| Message-ID: | 19830.1135351375@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Michael Fuhr <mike(at)fuhr(dot)org> writes:
> Unless I'm missing something that wouldn't use an index either,
> because the planner wouldn't know what value to compare start_date
> against without hitting each row to find that row's time_to_live.
> But something like this should be able to use an expression index
> on (start_date + time_to_live):
> WHERE start_date + time_to_live < now()
Or perhaps simpler, get rid of time_to_live in favor of an end_date
column, which could be indexed directly.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-23 16:04:50 | Re: Indices for select count(*)? |
| Previous Message | Peter Eisentraut | 2005-12-23 15:12:37 | Re: Indices for select count(*)? |