Re: inconsistent/weird index usage

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dustin Sallings <dustin(at)spy(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: inconsistent/weird index usage
Date: 2004-10-01 16:29:36
Message-ID: 200410010929.36026.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-10-01 16:34:15 Re: inconsistent/weird index usage
Previous Message Matt Clark 2004-10-01 15:46:59 Re: Caching of Queries