Re: date index problems - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: date index problems
Date
Msg-id 095101c2ef66$a6960f30$6500a8c0@fhp.internal
Whole thread Raw
In response to date index problems  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> Surely the planner is aware that '2003-01-01'::date - interval '1 week' is
a
> constant???

Actually, turns out that the planner was smarter than me I think. 2003-01-01
occurs very rarely in the system, but other dates occupy 1/7th of the table,
so it's not so easy to plan...

Chris



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: date index problems
Next
From: Gavin Sherry
Date:
Subject: Re: date index problems