Thread: pg_sorttemp11938.0

pg_sorttemp11938.0

From
"Ingram, Bryan"
Date:
I've got a file called pg_sorttemp11938.0 in the data directory of one of my
databases.

This file is over 250 megs in size!!

Can I delete this file?

Thanks,
Bryan


Re: pg_sorttemp11938.0

From
Tom Lane
Date:
"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