Re: Including Snapshot Info with Indexes

Поиск
Список
Период
Сортировка
От Gokulakannan Somasundaram
Тема Re: Including Snapshot Info with Indexes
Дата
Msg-id 9362e74e0710140920p457179day17100083cd58e545@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Including Snapshot Info with Indexes  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers


On 10/14/07, Gregory Stark <stark@enterprisedb.com> wrote:
"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.

In the new proposal, deletes are going to update indexes. So  its a trade-off between  selects and deletes, since selects may not need to goto the table for checking visibility. You may go through this thread, to get more details.

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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Back-patch support for python 2.5?
Следующее
От: "Gokulakannan Somasundaram"
Дата:
Сообщение: Re: Including Snapshot Info with Indexes