On Tue, Apr 13, 2010 at 11:06 AM, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > Jaime Casanova wrote: >> >> i will read it on the morning and the thread where it is, something >> that seems strange to me is that the patch touch twophase.c and >> twophase.h, why? > > When you start hot standby from an online checkpoint, the XIDs of any > two-phase transactions are included in the running-xacts record, just > like any other in-progress transactions. At a shutdown checkpoint, we > know that no regular transactions are in-progress, but there can be > transactions in prepared state, which need to be considered as > in-progress in the standby, but there's no information about them in the > shutdown record. So we scan pg_twophase to discover them. > >
ah! that makes sense... thanks -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers