temp_buffers

On Thu, Jul 07, 2005 at 04:16:58PM -0700, Joshua D. Drake wrote:

Can someone give me a reasonable explanation of what temp_buffers is for?

Number of buffers to be used for temp tables. Think shared_buffers, but
local to a connection instead of shared.

They are also used for new relations, in the transaction they are being
created. Because no one else can see the relation, there's no point in
sharing their pages.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"�Que diferencia tiene para los muertos, los hu�rfanos, y aquellos que han
perdido su hogar, si la loca destrucci�n ha sido realizada bajo el nombre
del totalitarismo o del santo nombre de la libertad y la democracia?" (Gandhi)

Alvaro Herrera <alvherre@alvh.no-ip.org> writes:

On Thu, Jul 07, 2005 at 04:16:58PM -0700, Joshua D. Drake wrote:

Can someone give me a reasonable explanation of what temp_buffers is for?

Number of buffers to be used for temp tables. Think shared_buffers, but
local to a connection instead of shared.

They are also used for new relations, in the transaction they are being
created. Because no one else can see the relation, there's no point in
sharing their pages.

No, temp buffers are *only* used for temp tables. Several versions back
the code acted as you say, but we got rid of that because it was more of
a headache than it was worth.

regards, tom lane