Re: Including Snapshot Info with Indexes

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Including Snapshot Info with Indexes
Дата
Msg-id 87fy0du8d4.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: Including Snapshot Info with Indexes  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
Ответы Re: Including Snapshot Info with Indexes  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
Список pgsql-hackers
"Gokulakannan Somasundaram" <gokul007@gmail.com> writes:

> So Indexes with snapshots will be degrading the performance only for deletes
> and only those updates, which are updating the index tuple.

Deletes never update indexes in Postgres. Increasing the size of the index
would affect vacuum, inserts, and index accesses.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: "Gokulakannan Somasundaram"
Дата:
Сообщение: Re: Including Snapshot Info with Indexes
Следующее
От: "Trevor Talbot"
Дата:
Сообщение: Re: Including Snapshot Info with Indexes