Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: Meaning of .log_cnt?
Date
Msg-id 200304041712.44126.dev@archonet.com
Whole thread Raw
In response to Meaning of .log_cnt?  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: Meaning of .log_cnt?  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tree view 
On Friday 04 Apr 2003 4:32 pm, Ed L. wrote:
> For a sequence called xxx, what is the meaning of the column
> xxx_seq.log_cnt?

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.

--
  Richard Huxton

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: feature request - adding columns with default value
Next
From: Joe Conway
Date:
Subject: Re: hex to decimal and back again