Re: temp_buffers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: temp_buffers
Date
Msg-id 7317.1120792902@sss.pgh.pa.us
Whole thread Raw
In response to Re: temp_buffers  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Must be owner to truncate?
Next
From: Tom Lane
Date:
Subject: Re: Hmmm 8.1 pg_dumpall cannot dump older db's?