> Someone asked about this at FOSDEM. The only way I know to do it is look
> in the pgsql_temp directory, but they disappear pretty quickly. Folks,
> do we need something to report sort file usage?
How about a new GUC variable: log_sort_tempfiles
And in the code that creates the temp file, if the GUC variable is true,
then do:
elog(LOG, "Sort needed temp file. Sort required 2456K. Try increasing
sort_mem.");
Or something?
Chris