Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > -1 to second: If there are any temporary deleted files then it is > > because we've done a large sort, hash join etc, so avoiding the sync > > makes no difference to the overall response time. > > I think you're confused, actually: this is not about temporary sort > files, it's about dropping temp relations. The scenario for this to > happen in ABORT is a rollback of a transaction that made a temp table.
Why don't we create temp tables in a separate directory, anyway? That would make it trivially easy to get rid of them during recovery: just zap all the files in there. -- Alvaro Herrera http://www.flickr.com/photos/alvherre/ Essentially, you're proposing Kevlar shoes as a solution for the problem that you want to walk around carrying a loaded gun aimed at your foot. (Tom Lane) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly