Re: Interpreting shared_buffers setting

2019-01-29 Thread Jerry Sievers
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

Re: Interpreting shared_buffers setting

2019-01-29 Thread Jerry Sievers
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

Re: Interpreting shared_buffers setting

2019-01-29 Thread Bob Jolliffe
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. > >

Re: Interpreting shared_buffers setting

2019-01-29 Thread Andrew Gierth
> "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

Re: Interpreting shared_buffers setting

2019-01-29 Thread Thomas Markus
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_

Interpreting shared_buffers setting

2019-01-29 Thread 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_buffers = 1GB Yet when I check the setting from pg_setting I see something quite different: postgres=# SELECT name,