Re: temp_buffers - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: temp_buffers
Date
Msg-id 20050707232408.GA28108@alvh.no-ip.org
Whole thread Raw
In response to temp_buffers  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: temp_buffers
List pgsql-hackers
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)


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: temp_buffers
Next
From: Josh Berkus
Date:
Subject: Re: SQL99 - Nested Tables