| Lists: | pgsql-docspgsql-general |
|---|
| From: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | sequences: cache_value, log_cnt, is_cycled columns |
| Date: | 2003-10-27 20:53:50 |
| Message-ID: | 20031027205350.64626.qmail@web40601.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs pgsql-general |
I was just wondering, what are the "cache_value",
"long_cnt", and "is_cycled" sequence columns used for?
I couldn't find anything in the docs or Google.
select * from test_id_seq;
sequence_name | last_value | increment_by | max_value
| min_value | cache_value | log_cnt | is_cycled |
is_called
---------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
test_id_seq | 1 | 1 | 9223372036854775807 | 1 | 1 | 1
| f | f
(1 row)
__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] sequences: cache_value, log_cnt, is_cycled columns |
| Date: | 2003-10-27 21:28:24 |
| Message-ID: | 14277.1067290104@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs pgsql-general |
CSN <cool_screen_name90001(at)yahoo(dot)com> writes:
> I was just wondering, what are the "cache_value",
> "long_cnt", and "is_cycled" sequence columns used for?
cache_value: CACHE parameter from CREATE SEQUENCE
is_cycled: CYCLE parameter from CREATE SEQUENCE
log_cnt: internal use (number of values available without writing
another WAL log entry, I think)
Docs folk: is it useful to document the columns of sequence objects,
or should we consider them all internal info? If they should be
documented, where? I'm kind of inclined to make an entry in the "system
catalogs" chapter, but I dunno what to title it ...
regards, tom lane