Re: the big picture for index-only scans

Поиск
Список
Период
Сортировка
От Gokulakannan Somasundaram
Тема Re: the big picture for index-only scans
Дата
Msg-id CAHMh4-ZeSXcFFeseFO9nAeL_25CjAUZnfvtoR7-0QUCBZ4iL-g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: the big picture for index-only scans  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: the big picture for index-only scans  (Gokulakannan Somasundaram <gokul007@gmail.com>)
Список pgsql-hackers

Well, that would certainly be alarming if true, but I don't think it
is.  As far as I can see, the overhead of making the visibility map
crash-safe is just (1) a very small percentage increase in the work
being done by VACUUM and (2) a slight possibility of extra work done
by a foreground process if the visibility map bit changes at almost
exactly the same time the process was about to insert, update, or
delete a tuple.

Let's forget the overhead posed by vacuum. Can you please point me to the design which talks in detail of the second overhead?

Thanks.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: New copyright program
Следующее
От: Gokulakannan Somasundaram
Дата:
Сообщение: Re: the big picture for index-only scans