Re: Missing DATE selectivity

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Missing DATE selectivity
Date: 2005-12-28 04:00:20
Message-ID: 200512280400.jBS40KF27381@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs wrote:
> The TODO list has an item "add missing date selectivity", which is a
> hang-over from 1999 or before.
>
> Is this still an issue? Can somebody describe exactly what it is?
>
> I can't find the exact discussion of what the problem was/is, so its
> better to ask directly...

Good question. I see DATEOID in selfuncs.c, so my guess is that at one
time we didn't have it, but now we do, and I never realized it. I have
removed the mention and updated the entry to:

* Add missing rtree optimizer selectivity

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeremy Drake 2005-12-28 04:30:15 Re: sending mail from Postgres
Previous Message Aftab Alam 2005-12-28 03:22:41 sending mail from Postgres