Re: Hot Standby (v9d)

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Hot Standby (v9d)
Дата
Msg-id 4979EEBD.5060108@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Hot Standby (v9d)  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Hot Standby (v9d)  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
> @@ -1601,6 +1602,24 @@ BufferProcessRecoveryConflictsIfAny(volatile BufferDesc *bufHdr)
>         {
>                 XLogRecPtr      bufLSN = BufferGetLSN(bufHdr);
>  
> +               /*
> +                * If the buffer is recent we may need to cancel ourselves
> +                * rather than risk returning a wrong answer. This test is
> +                * too conservative, but it is correct.
> +                *
>>> +                * We only need to cancel the current subtransaction.
> +                * Once we've handled the error then other subtransactions can
> +                * continue processing. Note that we do *not* reset the
> +                * BufferRecoveryConflictLSN at subcommit/abort, but we do
> +                * reset it if we release our last remaining sbapshot.
> +                * see SnapshotResetXmin()
> +                *

Is it really enough to cancel just the current subtransaction? What if 
it's a serializable transaction?

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: autovacuum and reloptions
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Controlling hot standby