Re: [HACKERS] Missing DATE selectivity
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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Missing DATE selectivity
Simon Riggs [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Missing DATE selectivity
Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] 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, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Missing DATE selectivity
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, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq