> > Permission to put this in 6.1p1?
>
> By all means...
Thomas says no for 6.1p1. I have no opinion on this. However, I don't
want to rush out a fix until I have heard from Paul M. Aoki and Vadim,
and gotten their opinion for the most efficient way to fix this.
>
> My next question is what is considered a 'small SELECT result'? If
> I have a 32Meg machine, that 'small' would be different, I would assume,
> then a 128Meg machine.
I think the sort is used by ORDER BY and joins where this is not an
existing index.
> With that in mind, how about some sort of 'switch', similar to
> -B, that allows you to stipulate total RAM of a machine (or virtual memory?),
> or something similar to that?
I am not sure how to do this. There is sysctl() and getconf(), but
neither of them is standard on all platforms.
- --
Bruce Momjian
maillist@candle.pha.pa.us
------------------------------