Re: BUG #3401: PITR does not work in the case ofrecovery_target_xid = 'SELECT_only_transaction_ID'

On Thu, 2007-06-21 at 11:17 +0000, Katsuhiko Okano wrote:

> Description:        PITR does not work in the case of recovery_target_xid =
> 'SELECT_only_transaction_ID'
> Details:

If a transaction is purely read only then there is no COMMIT or ABORT
message written to the transaction log. As a result there is no way to
know at what point that transaction occurred, nor any way to use the
recovery_target_xid on those kinds of transactions. This is not a bug in
PITR, it is a specific optimisation of WAL to improve the throughput of
read-only queries.

I'll add this to the docs in my next round of docs changes.

How did you come to choose an xid of this nature?

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com