Re: Accessing schema data in information schema
От | Hannu Krosing |
---|---|
Тема | Re: Accessing schema data in information schema |
Дата | |
Msg-id | 1143065455.3868.3.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Accessing schema data in information schema (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Accessing schema data in information schema
Re: Accessing schema data in information schema |
Список | pgsql-hackers |
Ü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
В списке pgsql-hackers по дате отправления: