От: Ivan Voras
Тема: Re: MVCC & indexes?
Дата: ,
Msg-id: 45488DB1.9010005@fer.hr
(см: обсуждение, исходный текст)
Ответ на: Re: MVCC & indexes?  (Alvaro Herrera)
Список: pgsql-performance

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

MVCC & indexes?  (Ivan Voras, )
 Re: MVCC & indexes?  (Alvaro Herrera, )
  Re: MVCC & indexes?  (Ivan Voras, )
 Re: MVCC & indexes?  (, )

Alvaro Herrera wrote:

> Well, there certainly is locking involved in inserting index entries,
> but it's more fine-grained than you seem to think.  Only one page of the
> index is locked at any time, resulting in that typically there's very
> little blocking involved.  Two processes can be inserting into the same
> index concurrently (btree and GiST indexes at least; GiST only gained
> concurrency in a recent release, I don't remember if it was 8.0 or 8.1).

Thank you, this was the bit I was missing. In retrospect, I don't really
know how I came to conclusion the whole index was being locked :(



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

От: Matthew O'Connor
Дата:
Сообщение: Re: Database-wide vacuum can take a long time, during which
От: "Simon Riggs"
Дата:
Сообщение: Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed