Re: Setting shared_buffers No Effect

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Setting shared_buffers No Effect
Дата
Msg-id 1103.1523989675@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Setting shared_buffers No Effect  (Lorne Wanamaker <feldan1@gmail.com>)
Ответы Re: Setting shared_buffers No Effect  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-novice
Lorne Wanamaker <feldan1@gmail.com> writes:
> Trying to set shared_buffers to 256MB but seems not to take effect. I have
> in postgresql.conf:
> shared_buffers = 256MB
> Have restarted the service. Yet when using "SHOW shared_buffers" it returns
> 4MB. Query being run in pgAdmin4.

Maybe there's another setting later in the file, or in
postgresql.auto.conf?  This would give you a clearer
idea of where the active setting is coming from:

select source,sourcefile,sourceline from pg_settings
  where name = 'shared_buffers';

            regards, tom lane


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

Предыдущее
От: Lorne Wanamaker
Дата:
Сообщение: Setting shared_buffers No Effect
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Setting shared_buffers No Effect