--On Freitag, Mai 25, 2007 10:49:29 +0000 Jaime Casanova <[EMAIL PROTECTED]> wrote:

No, because the RemovePgTempFiles() call in PostmasterMain() will
remove all tmp files at startup.

Hmm isn't RemovePgTempFiles() called on postmaster startup only? What will happen if a temp tablespace is out of disk space, and the backend leaves all previously created temp files there? Under these assumption we'll need to restart the postmaster to get a clean tablespace ready to drop...

--
 Thanks

                   Bernd

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to