Re: How to accurately determine when a relation should use local buffers? - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: How to accurately determine when a relation should use local buffers?
Date
Msg-id CAJ7c6TPso_SqmAooUJCu5gXdM68YPjnt4KS80zTdCq0pLpb1cA@mail.gmail.com
Whole thread Raw
In response to Re: How to accurately determine when a relation should use local buffers?  (Давыдов Виталий <v.davydov@postgrespro.ru>)
Responses Re: How to accurately determine when a relation should use local buffers?
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: remaining sql/json patches
Next
From: Shubham Khanna
Date:
Subject: Re: Improve tab completion for ALTER DEFAULT PRIVILEGE and ALTER TABLE