Thread: Missing DATE selectivity
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
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
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
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
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