Horton

Re: inconsistent/weird index usage

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Dustin Sallings <dustin@spy.net>, pgsql-performance@postgresql.org
Date: 2004-10-01T16:29:36Z
Lists: pgsql-performance 
Tom,

> Most of the problem here comes from the fact that "current_date - 7"
> isn't reducible to a constant and so the planner is making bad guesses
> about how much of each table will be scanned.  

I thought this was fixed in 7.4.  No?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco