Postgres Pro
Downloads
Home   >   mailing lists

Re: Forcing filter/join order? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Forcing filter/join order?
Date
Msg-id 200402191317.35344.josh@agliodbs.com
Whole thread Raw
In response to Re: Forcing filter/join order?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Tom,

> 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
workaround.   Thanks!

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-performance by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Optimizer difference using function index between 7.3 and 7.4
Next
From:
Date:
Subject: Slow in morning hours