Re: OID wraparound (was Re: pg_depend)
От | Tom Lane |
---|---|
Тема | Re: OID wraparound (was Re: pg_depend) |
Дата | |
Msg-id | 14468.995495192@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | RE: OID wraparound (was Re: pg_depend) ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>) |
Ответы |
Re: OID wraparound (was Re: pg_depend)
Re: OID wraparound (was Re: pg_depend) |
Список | pgsql-hackers |
>> I meant we use them in many cases to link entries, and in >> pg_description for descriptions and lots of other things >> that may use them in the future for system table use. pg_description is a point I hadn't thought about --- it uses OIDs to refer to pg_attribute entries. However, pg_description is pretty broken in its assumptions about OIDs anyway. I'm inclined to change it to be indexed by (object type ID, object OID, attributenumber) the same way that Philip proposed indexing pg_depend. Among other things, that'd make it much cheaper to drop comments during a DROP TABLE. You could just scan on (object type ID, object OID), and get both the table and all its columns in a single indexscan search, not one per column as happens now. regards, tom lane
В списке pgsql-hackers по дате отправления: