Skip site navigation (1) Skip section navigation (2)

Re: Forcing filter/join order?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>,pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Forcing filter/join order?
Date: 2004-02-19 21:17:35
Message-ID: 200402191317.35344.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

pgsql-performance by date

Next:From: V ChitraDate: 2004-02-20 06:56:22
Subject: Index called with Union but not with OR clause
Previous:From: Simon RiggsDate: 2004-02-19 20:58:03
Subject: Re: Optimizer difference using function index between 7.3 and 7.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group