Robert Treat wrote: > is there some way to determine the query that creates the file > pgsql_tmp15041.0? i thought maybe 15041 was the procpid but apparently > not... anyone know?
It is the proc id. Perhaps the backend crashed. If so, a postmaster restart clears those sort directories. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
