Mark,

> -----Original Message-----
> From: mark@mark.mielke.cc [mailto:mark@mark.mielke.cc]
> Sent: Friday, July 28, 2006 9:26 PM
>
> But irrefutable? Irrefutable is not true. :-)

How about unrefuted. The evidence has not been refuted, and not
directly discussed or discounted.

BTREE can not be optimized to produce the results we've presented, the
discussion about char(n) datatypes was irrelevant as we had shown
results for INT, numeric and char/varchar and they were all dramatically
better than BTREE.

I am hopeful this discussion takes a rapid turn toward the quantitative
assessment of the results.

- Luke


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Luke Lonergan wrote:
> Mark,
>
> > -----Original Message-----
> > From: mark@mark.mielke.cc [mailto:mark@mark.mielke.cc]
> > Sent: Friday, July 28, 2006 9:26 PM
> >
> > But irrefutable? Irrefutable is not true. :-)
>
> How about unrefuted. The evidence has not been refuted, and not
> directly discussed or discounted.
>
> BTREE can not be optimized to produce the results we've presented, the
> discussion about char(n) datatypes was irrelevant as we had shown
> results for INT, numeric and char/varchar and they were all dramatically
> better than BTREE.
>
> I am hopeful this discussion takes a rapid turn toward the quantitative
> assessment of the results.

Right. People need a patch to test on their workloads, and analysis can
be done after feature freeze.

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Bruce,

On 7/29/06 6:31 AM, "Bruce Momjian" <bruce@momjian.us> wrote:

> Right. People need a patch to test on their workloads, and analysis can
> be done after feature freeze.

Fair enough.

- Luke



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings