Lorne Wanamaker <feldan1(at)gmail(dot)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