Skip site navigation (1) Skip section navigation (2)

Re: Advice on MyXactMade* flags, MyLastRecPtr,pendingDeletes and lazy XID assignment

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>, Postgresql-Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Advice on MyXactMade* flags, MyLastRecPtr,pendingDeletes and lazy XID assignment
Date: 2007-08-30 21:02:08
Message-ID: 1188507728.4173.13.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, 2007-08-30 at 14:14 -0400, Tom Lane wrote:
> "Florian G. Pflug" <fgp(at)phlo(dot)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.)

Agreed

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


In response to

pgsql-hackers by date

Next:From: Simon RiggsDate: 2007-08-30 21:34:42
Subject: synchronous_commit: Developer's View
Previous:From: Simon RiggsDate: 2007-08-30 21:01:25
Subject: Re: Advice on MyXactMade* flags, MyLastRecPtr,pendingDeletes and lazy XID assignment

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group