OID vs overall system performances on high load

От: Eric Lauzon
Тема: OID vs overall system performances on high load
Дата: ,
Msg-id: F7B73864DD39FA40B6C56B3CE0D4D1CB1B4466@asdc003.abovesecurite.lan
(см: обсуждение, исходный текст)
Ответы: Re: OID vs overall system performances on high load  (Andrew McMillan)
Re: OID vs overall system performances on high load  (Tom Lane)
Re: OID vs overall system performances on high load  (Neil Conway)
Список: pgsql-performance

Скрыть дерево обсуждения

OID vs overall system performances on high load  ("Eric Lauzon", )
 Re: OID vs overall system performances on high load  (Andrew McMillan, )
 Re: OID vs overall system performances on high load  (Tom Lane, )
 Re: OID vs overall system performances on high load  (Neil Conway, )

I am still in the dark due to my lack of knowledge on internal OID management,but
i would presume that a table with OID enable and that has high load would require
some more work from pgsql internal to maintain the OID index for the database.

So OID can be beneficial on static tables, or tables that you want to be able to manipulate
with pgadmin X , but can a table without OID increase performances on insert,delete,update,COPY?

I am not really worried about disk space that an OID collumn can take, but i was wandering if an
insert in a table of 20 millions and more that has oid would slow the insert process. Since OID seem
to act as a global index mabey maintaning that index can become costy over high table load by postgresql
backend.

-Eric Lauzon








В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: OID vs overall system performances on high load
От: Neil Conway
Дата:
Сообщение: Re: OID vs overall system performances on high load