Re: Meaning of <sequence>.log_cnt?

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-04-04 16:14:44 Re: hex to decimal and back again
Previous Message Josh Berkus 2003-04-04 16:09:22 Re: [PERFORM] OSS database needed for testing