Column Index vs Record Insert Trade-off?

Поиск
Список
Период
Сортировка
От Ken Hill
Тема Column Index vs Record Insert Trade-off?
Дата
Msg-id 1139450040.15713.3.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: Column Index vs Record Insert Trade-off?  (Richard Huxton <dev@archonet.com>)
Список pgsql-sql
Is there a performance trade-off between column indexes and record inserts?<br /><br /> I know that in MS Access there
issuch a trade-off. This being indexes make SQL queries perform faster at the cost of record insert speed. Put another
way,the more column indexes in a table, the slower a record insert in that table performs.<br /><br /> Is there a
similartrade-off in PostgreSQL?  

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

Предыдущее
От: Bricklen Anderson
Дата:
Сообщение: Re: Syntax for "IF" clause in SELECT
Следующее
От: george young
Дата:
Сообщение: unique constraint instead of primary key? what disadvantage(ODBC usage)?