Re: effective_cache_size cannot be changed by a reload

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: effective_cache_size cannot be changed by a reload
Дата
Msg-id CAHGQGwGgFq+2NSjsq=XE+9MhOOeT6+u95OhqZ0sCt0vq_D1CHA@mail.gmail.com
обсуждение исходный текст
Ответ на effective_cache_size cannot be changed by a reload  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: effective_cache_size cannot be changed by a reload  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, Mar 20, 2014 at 2:34 AM, Jeff Janes <jeff.janes@gmail.com> wrote:
> In 9.4dev, if the server is started with effective_cache_size = -1, then it
> cannot be changed away from that without a restart.  If you change the
> config file and do a reload or pg_reload_conf(), it ignores the change
> without comment in the logs.
>
> If you start the server with a value other than -1, then you can change the
> value by editing the file and doing a reload.  You can even change it to -1,
> and then change it back away from -1 again.

I think that's a bug. Patch attached.

> I don't know if bugs reports (without patches) against pre-release versions
> are supposed to go to hackers or to bugs.

Either works at least for me.

Regards,

--
Fujii Masao

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Petr Jelinek
Дата:
Сообщение: Re: Review: plpgsql.extra_warnings, plpgsql.extra_errors
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: jsonb and nested hstore