Re: Meaning of <sequence>.log_cnt?

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Meaning of <sequence>.log_cnt?
Date: 2003-04-04 16:20:10
Message-ID: 200304040920.10797.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday April 4 2003 9:12, Richard Huxton wrote:
>
> IIRC sequence numbers are handed out in batches rather than one at a
> time, to reduce contention between backends. I think this is the number
> of unused sequence numbers in the batch.

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?

Ed

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2003-04-04 16:24:20 Re: dbmirror revisions
Previous Message Dennis Gearon 2003-04-04 16:19:24 Re: feature request - adding columns with default value