Обсуждение: Setting shared_buffers No Effect

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

On Tue, Apr 17, 2018 at 1:27 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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';

Another super obvious thing to point out is that shared_buffers takes
effect after starting the server.

merlin