Jerry Sievers writes:
> Bob Jolliffe writes:
>
>> Excuse me if this is a silly question. I am trying to fiddle with
>> shared_buffers setting on postgresql 10.6 on ubuntu 18.04 server.
>>
>> I have this at bottom of my config file:
>> shared_buffers = 1GB
>>
>> Yet when I check the setting from
Bob Jolliffe writes:
> Excuse me if this is a silly question. I am trying to fiddle with
> shared_buffers setting on postgresql 10.6 on ubuntu 18.04 server.
>
> I have this at bottom of my config file:
> shared_buffers = 1GB
>
> Yet when I check the setting from pg_setting I see something quite
Thank you Andrew and Thomas. All is now clear :-)
On Tue, 29 Jan 2019 at 13:07, Andrew Gierth wrote:
>
> > "Bob" == Bob Jolliffe writes:
>
> Bob> Excuse me if this is a silly question. I am trying to fiddle with
> Bob> shared_buffers setting on postgresql 10.6 on ubuntu 18.04 server.
>
>
> "Bob" == Bob Jolliffe writes:
Bob> Excuse me if this is a silly question. I am trying to fiddle with
Bob> shared_buffers setting on postgresql 10.6 on ubuntu 18.04 server.
Bob> I have this at bottom of my config file:
Bob> shared_buffers = 1GB
Bob> Yet when I check the setting from p
Hi,
check for blocksize (8k) as factor.
8k*131072=1G
regards
Thomas
Am 29.01.19 um 13:32 schrieb Bob Jolliffe:
Excuse me if this is a silly question. I am trying to fiddle with
shared_buffers setting on postgresql 10.6 on ubuntu 18.04 server.
I have this at bottom of my config file:
shared_
Excuse me if this is a silly question. I am trying to fiddle with
shared_buffers setting on postgresql 10.6 on ubuntu 18.04 server.
I have this at bottom of my config file:
shared_buffers = 1GB
Yet when I check the setting from pg_setting I see something quite different:
postgres=# SELECT name,