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

Reply via email to