Re: Meaning of .log_cnt? - Mailing list pgsql-general

From Tom Lane
Subject Re: Meaning of .log_cnt?
Date
Msg-id 7487.1049476267@sss.pgh.pa.us
Whole thread Raw
In response to Re: Meaning of .log_cnt?  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
"Ed L." <pgsql@bluepolka.net> writes:
> If you were wanting to sync a sequence on 2 separate dbs, as in master-slave
> replication, log_cnt would not be a column you would care about?

I don't believe so.  My recollection is that it's actually the number of
IDs available before we have to write another WAL log entry for the
sequence.  So unless you're using a replication method that can get at
WAL entries, it's a non-issue.

            regards, tom lane


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Meaning of .log_cnt? (WRT REPLICATION)
Next
From: Tom Lane
Date:
Subject: Re: heap_mark4update error on UPDATE