Re: Accessing schema data in information schema

Ühel kenal päeval, K, 2006-03-22 kell 16:11, kirjutas Tom Lane:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > How does one get at the missing fields.  The only way I know is 
> > selecting from the sequence, but how does one work this into this 
> > query?  Somehow it seems that these things should be stored in a real 
> > system catalog.
> 
> Yeah.  I've occasionally toyed with the idea that sequences should be
> rows in a single catalog instead of independent tables as they are now.
> This would make for a much smaller disk footprint (with consequent I/O
> savings) and would solve problems like the one you have. 

Would it not make page locking problems much worse with all get_next()'s
competeing to update the same page? 

At least unless you reserve one page for each sequence.

-------------
Hannu