Re: [HACKERS] \dt and disk access

> > It looks like psort()'s use of disk files to do the sorting is causing
> > the slowdown, with the multiple create's and unlink's.  I am going to
> > modify psort() to use memory buffers instead of disk files for sorting
> > small SELECT results.  psort() is only called by ExecSort, which is used
> > by ORDER BY's.
> >
> > Permission to put this in 6.1p1?
>
> Can you make the size of the result set above which diskfiles will be used
> configurable? That way ppl with loads of RAM can use huge buffers, and ppl
> with little RAM can keep that RAM free for other processes.

If I need a configuration value, I will either determine the amount of
RAM portably, or base the value on the number of shared buffers
requested with -B.

- --
Bruce Momjian
maillist@candle.pha.pa.us

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