Re: GUC variable for setting number of local buffers - Mailing list pgsql-hackers

From Markus Bertheau
Subject Re: GUC variable for setting number of local buffers
Date
Msg-id 1111325265.2589.1.camel@umnik
Whole thread Raw
In response to GUC variable for setting number of local buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: GUC variable for setting number of local buffers  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: GUC variable for setting number of local buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
В Сбт, 19/03/2005 в 12:57 -0500, Tom Lane пишет:

> It's already true that the individual buffers, as opposed to the buffer
> descriptors, are allocated only as needed; which makes the overhead
> of a large local_buffers setting pretty small if you don't actually do
> much with temp tables in a given session.  So I was thinking about
> making the default value fairly robust, maybe 1000 (as compared to
> the historical value of 64...).

Why does the dba need to set that variable at all then?

--
Markus Bertheau <twanger@bluetwanger.de>

pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: read-only planner input
Next
From: Bruce Momjian
Date:
Subject: Re: GUC variable for setting number of local buffers