Re: Low hanging fruit in lazy-XID-assignment patch? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Low hanging fruit in lazy-XID-assignment patch?
Date
Msg-id 20070908162123.GA5290@alvh.no-ip.org
Whole thread Raw
In response to Re: Low hanging fruit in lazy-XID-assignment patch?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Low hanging fruit in lazy-XID-assignment patch?
List pgsql-hackers
As a fallout of this work that I haven't seen made explicit, a session
opening a transaction and then sitting around doing nothing will not
cause as many problems as it used to -- for example it won't cause
VACUUM to be unable to clean up dead rows.  Is this correct?

Nowadays this is no longer much of a problem, but it used to be, back
when drivers were more broken than they are now (when they had the
commit method send "COMMIT; BEGIN"); however, it still seems to me like
a big step forwards.

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Siempre hay que alimentar a los dioses, aunque la tierra esté seca" (Orual)


pgsql-hackers by date:

Previous
From: apoc9009
Date:
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Next
From: Tom Lane
Date:
Subject: Re: Low hanging fruit in lazy-XID-assignment patch?