Re: Recovery Features
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2004-07-05T21:30:56Z
Lists: pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes: > ...While recovering, it is very straightforward to simply ignore every > record associated with one (or more) transactions. That gives us the > ability to recover "all apart from txnid X". Don't even *think* of going there. What will happen when transaction Y comes along and wants to modify or delete a row that was inserted by X? There's no chance of staying consistent. regards, tom lane