pg_sorttemp11938.0

Started by Ingram, Bryanover 25 years ago2 messagesgeneral
Jump to latest
#1Ingram, Bryan
BIngram@sixtyfootspider.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ingram, Bryan (#1)
Re: pg_sorttemp11938.0

"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