Re: date index problems

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: date index problems
Date: 2003-03-21 04:59:27
Message-ID: 095101c2ef66$a6960f30$6500a8c0@fhp.internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2003-03-21 05:03:34 Re: date index problems
Previous Message Christopher Kings-Lynne 2003-03-21 04:53:44 date index problems