Setting shared_buffers No Effect

[Lorne Wanamaker]

Hi,

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.

Configuration file is the correct one according to "SHOW config_file;"

Sure I am missing something something simple, any ideas?

Thanks,
Lorne

[Tom Lane]

Post by Lorne Wanamaker
Trying to set shared_buffers to 256MB but seems not to take effect. I have
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

[Merlin Moncure]

Post by Tom Lane

Post by Lorne Wanamaker
Trying to set shared_buffers to 256MB but seems not to take effect. I have
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
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