| Lists: | pgsql-hackers |
|---|
| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Missing DATE selectivity |
| Date: | 2005-12-24 10:10:06 |
| Message-ID: | 1135419006.2964.625.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| 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 |
| 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
| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Missing DATE selectivity |
| Date: | 2005-12-29 10:59:56 |
| Message-ID: | 1135853996.2964.706.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Missing DATE selectivity |
| Date: | 2005-12-29 16:00:15 |
| Message-ID: | 7200.1135872015@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Simon Riggs <simon(at)2ndquadrant(dot)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
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Missing DATE selectivity |
| Date: | 2005-12-29 16:45:19 |
| Message-ID: | 200512291645.jBTGjJu04726@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)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(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