"Wouter D'Haeseleer" <wdh@xxxxxxxxx> writes: > I have a question about sequences in combination with streaming > replication. > It seems something strange is happening with sequences which are > streamed to the slave. > When updating the sequence the last_value on the slave shifts with 32 > and halts at this value until the master increased the value also with > 32. > Is this normal behavior ? Yes, this is expected because of the hacks that are used to minimize the number of WAL records emitted during nextval() operations. The slave is seeing the state that would prevail on the master, too, if the master were to crash and restart. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
