Re: How to accurately determine when a relation should use local buffers?

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: How to accurately determine when a relation should use local buffers?
Дата
Msg-id CAJ7c6TPso_SqmAooUJCu5gXdM68YPjnt4KS80zTdCq0pLpb1cA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to accurately determine when a relation should use local buffers?  (Давыдов Виталий <v.davydov@postgrespro.ru>)
Ответы Re: How to accurately determine when a relation should use local buffers?  (Давыдов Виталий <v.davydov@postgrespro.ru>)
Список pgsql-hackers
Hi,

> There are some changes in ReadBuffer logic if to compare with pg15. To define which buffers to use, ReadBuffer used
SmgrIsTempfunction in pg15. The decision was based on backend id of the relation. In pg16 the decision is based on
relpersistenceattribute, that caused some problems on my side. My opinion, we should choose local buffers based on
backendids of relations, not on its persistence. Additional check for relpersistence prior to backend id may improve
theperformance in some cases, I think. The internal design may become more flexible as a result. 

Well even assuming this patch will make it to the upstream some day,
which I seriously doubt, it will take somewhere between 2 and 5 years.
Personally I would recommend reconsidering this design.

--
Best regards,
Aleksander Alekseev



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: remaining sql/json patches
Следующее
От: Shubham Khanna
Дата:
Сообщение: Re: Improve tab completion for ALTER DEFAULT PRIVILEGE and ALTER TABLE