Re: Meaning of <sequence>.log_cnt?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Meaning of <sequence>.log_cnt?
Date: 2003-04-04 17:11:07
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

"Ed L." <pgsql(at)bluepolka(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-04 17:28:02 Re: heap_mark4update error on UPDATE
Previous Message Richard Huxton 2003-04-04 17:08:38 Re: Meaning of <sequence>.log_cnt? (WRT REPLICATION)