Re: Exposing the Xact commit order to the user
От | Greg Sabino Mullane |
---|---|
Тема | Re: Exposing the Xact commit order to the user |
Дата | |
Msg-id | 95a6a1132b8673c6d0cb6cab25fe441e@biglumber.com обсуждение исходный текст |
Ответ на | Exposing the Xact commit order to the user (Jan Wieck <JanWieck@Yahoo.com>) |
Ответы |
Re: Exposing the Xact commit order to the user
|
Список | pgsql-hackers |
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > Exposing the data will be done via a set returning function. The SRF > takes two arguments. The maximum number of rows to return and the last > serial number processed by the reader. The advantage of such SRF is that > the result can be used in a query that right away delivers audit or > replication log information in transaction commit order. The SRF can > return an empty set if no further transactions have committed since, or > an error if data segments needed to answer the request have already been > purged. In light of the proposed purging scheme, how would it be able to distinguish between those two cases (nothing there yet vs. was there but purged)? - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201005231646 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkv5lIAACgkQvJuQZxSWSsiR3gCgvyK/NPd6WmKGUqdo/3fdWIR7 LAQAoJqk3gYpEgtjw10gINDKFXTAnWO5 =sSvK -----END PGP SIGNATURE-----
В списке pgsql-hackers по дате отправления: