Re: Hot Issue

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Hot Issue
Дата
Msg-id 12784.1215016531@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Hot Issue  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
Список pgsql-performance
"Gauri Kanekar" <meetgaurikanekar@gmail.com> writes:
> Better HOT performance means.... 1st stat showed most of the updated tuples
> getting hot.
> But the 2nd stat showed that most of the updated tuples are NOT getting hot.

Well, as was noted upthread, you'd want to reduce the table fillfactor
(not index fillfactor) below 100 to improve the odds of being able to
do HOT updates.  But I wonder whether your application behavior changed.
Are you updating the rows in a way that'd make them wider?

            regards, tom lane

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

Предыдущее
От: "Gauri Kanekar"
Дата:
Сообщение: Re: Hot Issue
Следующее
От: "Leví Teodoro da Silva"
Дата:
Сообщение: [QUESTION]Concurrent Access