From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Lorne Wanamaker <feldan1(at)gmail(dot)com>, pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Re: Setting shared_buffers No Effect |
Date: | 2018-04-17 18:29:07 |
Message-ID: | CAHyXU0xbucbSMGRuobdoX7CUZjBRvGXDxU_rgVVwJ_WYnAMcCg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, Apr 17, 2018 at 1:27 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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';
Another super obvious thing to point out is that shared_buffers takes
effect after starting the server.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | JORGE MALDONADO | 2018-04-18 14:01:02 | Extract date portion of a datetime field |
Previous Message | Tom Lane | 2018-04-17 18:27:55 | Re: Setting shared_buffers No Effect |