Thread: Missing DATE selectivity

Missing DATE selectivity

From
Simon Riggs
Date:
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...

Best Regards, Simon Riggs



Re: Missing DATE selectivity

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


Re: Missing DATE selectivity

From
Simon Riggs
Date:
On Tue, 2005-12-27 at 23:00 -0500, Bruce Momjian wrote:
> 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
> 

I thought rtree was no longer supported either...

Best Regards, Simon Riggs



Re: Missing DATE selectivity

From
Tom Lane
Date:
Simon Riggs <simon@2ndquadrant.com> writes:
> On Tue, 2005-12-27 at 23:00 -0500, Bruce Momjian wrote:
>> * Add missing rtree optimizer selectivity

> I thought rtree was no longer supported either...

We still have rtree-like opclasses.  I agree the TODO item is worded
in a way that makes it look obsolete though.  How about

* Improve selectivity functions for geometric operators
        regards, tom lane


Re: Missing DATE selectivity

From
Bruce Momjian
Date:
Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > On Tue, 2005-12-27 at 23:00 -0500, Bruce Momjian wrote:
> >> * Add missing rtree optimizer selectivity
> 
> > I thought rtree was no longer supported either...
> 
> We still have rtree-like opclasses.  I agree the TODO item is worded
> in a way that makes it look obsolete though.  How about
> 
> * Improve selectivity functions for geometric operators

Thanks, updated.

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