Re: [HACKERS] \dt and disk access

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

------------------------------