OID vs overall system performances on high load databases.

Поиск
Список
Период
Сортировка
От Eric Lauzon
Тема OID vs overall system performances on high load databases.
Дата
Msg-id F7B73864DD39FA40B6C56B3CE0D4D1CB634477@asdc003.abovesecurite.lan
обсуждение исходный текст
Ответы Re: OID vs overall system performances on high load
Список pgsql-performance
What are the effect of having a table with arround 500 insert/update/delete on two to eight table in a time frame of 2
minutes24/24h, when you have oid enabled versus the same setup when you dont have oid? 

That deployment is done on a postgres with 8 to 9 databases, each having those 2 to 8 high load tables with oid
enabled.

Would the oid colum slow down table scan when you have over 20 millions row?

Would the cost of maintaining the oid column inside thoses high load tables when there is no oid reference used for
dataseeking costy for postgres ressources!? 



Eric Lauzon
[Recherche & Développement]
Above Sécurité / Above Security
Tél  : (450) 430-8166
Fax : (450) 430-1858

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Close
Дата:
Сообщение: Re: slow queries, possibly disk io
Следующее
От: Jeffrey Tenny
Дата:
Сообщение: Redundant indexes?