"Ingram, Bryan" <BIngram@sixtyfootspider.com> writes:
> I've got a file called pg_sorttemp11938.0 in the data directory of one of my
> databases.
If you no longer have a running backend with PID 11938, then that file
is trash. Temp files are supposed to be cleaned up at backend exit,
but sometimes they're not...
regards, tom lane