--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