> event_date <= 'end-date' AND (event_date + duration) >= 'start-date'
> AND event_date >= 'start-date' - 'max-duration'
Great suggestion! We're down to 160ms, from about 370ms with my subselect
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: V Chitra||Date: 2004-02-20 06:56:22|
|Subject: Index called with Union but not with OR clause|
|Previous:||From: Simon Riggs||Date: 2004-02-19 20:58:03|
|Subject: Re: Optimizer difference using function index between 7.3 and 7.4|