Re: GUC variable for setting number of local buffers

Поиск
Список
Период
Сортировка
От Markus Bertheau
Тема Re: GUC variable for setting number of local buffers
Дата
Msg-id 1111325265.2589.1.camel@umnik
обсуждение исходный текст
Ответ на GUC variable for setting number of local buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: GUC variable for setting number of local buffers
Re: GUC variable for setting number of local buffers
Список 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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: read-only planner input
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: GUC variable for setting number of local buffers