On Sun, 22 Jun 1997, Bruce Momjian wrote:
> > 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.
Ummm...okay.
Now, what is considered a "small SELECT result"? :)
> > 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.
Huh? You seem to have totally missed the question on that one
there Bruce :( Where does sysctl() and getconf() fit into having a run
time switch? *confused look* *grin*
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
------------------------------
