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 CAJ7c6TPQV=ROJ2i6Wra6Gcz5HbhNq8HKpdu+DF=H4-otavg0DQ@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,

> I would propose not to associate temporary relations with local buffers

The whole point of why local buffers exist is to place the buffers of
temp tables into MemoryContexts so that these tables will not fight
for the locks for shared buffers with the rest of the system. If we
start treating them as regular tables this will cause a severe
performance degradation. I doubt that such a patch will make it.

I sort of suspect that you are working on a very specific extension
and/or feature for PG fork. Any chance you could give us more details
about the case?

-- 
Best regards,
Aleksander Alekseev



pgsql-hackers by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: [PATCH] Add CHECK_FOR_INTERRUPTS in scram_SaltedPassword loop.
Next
From: Daniel Gustafsson
Date:
Subject: Re: [PATCH] Add CHECK_FOR_INTERRUPTS in scram_SaltedPassword loop.