Re: inconsistent/weird index usage - Mailing list pgsql-performance

From Josh Berkus
Subject Re: inconsistent/weird index usage
Date
Msg-id 200410010929.36026.josh@agliodbs.com
Whole thread Raw
In response to Re: inconsistent/weird index usage  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: inconsistent/weird index usage
List 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

pgsql-performance by date:

Previous
From: "Matt Clark"
Date:
Subject: Re: Caching of Queries
Next
From: Tom Lane
Date:
Subject: Re: inconsistent/weird index usage