Home > mailing lists

Setting shared_buffers No Effect - Mailing list pgsql-novice

From	Lorne Wanamaker
Subject	Setting shared_buffers No Effect
Date	April 18, 2018 00:15:24
Msg-id	CAEBAV9ra0ULwniYeCz8fudnKVznKoXekRpHuT4bwxJuqeqnPWg@mail.gmail.com Whole thread Raw
Responses	Re: Setting shared_buffers No Effect
List	pgsql-novice

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

From: "Saha, Sushanta K"
Date: 16 April 2018, 20:07:12
Subject: Re: [E] RE: dual active 2-node cluster?

From: Tom Lane
Date: 18 April 2018, 00:27:55
Subject: Re: Setting shared_buffers No Effect