On Thu, 2007-08-30 at 00:33 -0400, Tom Lane wrote: > "Florian G. Pflug" <[EMAIL PROTECTED]> writes: > > And I'm quite tempted to not flush the XLOG at all during ABORT, and to > > only force synchronous commits if one of the to-be-deleted files is > > non-temporary. > > +1 on the first, but -1 on the second, because we'd have to track > whether deleted files are temp or not ... it's very unclear that it'd > be worth the trouble.
+1 to first: Aborts aren't particularly frequent actions, but having them return faster makes sense if you have a session pool and people are waiting to run another transaction. -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. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(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