> > 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
------------------------------
