Re: Advice on MyXactMade* flags, MyLastRecPtr, pendingDeletes and lazy XID assignment - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Advice on MyXactMade* flags, MyLastRecPtr, pendingDeletes and lazy XID assignment
Date
Msg-id 4841.1188497640@sss.pgh.pa.us
Whole thread Raw
In response to Re: Advice on MyXactMade* flags, MyLastRecPtr, pendingDeletes and lazy XID assignment  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: Advice on MyXactMade* flags, MyLastRecPtr, pendingDeletes and lazy XID assignment  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
"Florian G. Pflug" <fgp@phlo.org> writes:
> So should we not force synchronous commit if all to-be-deleted files
> are temporary? Or is that pushing our luck too much, because it opens
> the window of possible file leakage considerably wider?

I think this area is something to be left for later.  Just worry about
XID avoidance for now, and maybe we'll revisit file creation/deletion
at another time.  (I'm not of the opinion that it's so broken that we
need to force two WAL flushes per file creation to fix it.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Why is there a tsquery data type?
Next
From: Andrew Dunstan
Date:
Subject: Re: enum types and binary queries