Re: DB running out of memory issues after upgrade

2020-02-23 Thread Peter J. Holzer
On 2020-02-18 18:10:08 +, Nagaraj Raj wrote: > Below are the same configurations ins .conf file before and after updagrade > > show max_connections; = 1743 [...] > show work_mem = "4MB" This is an interesting combination: So you expect a large number of connections but each one should use ver

Re: DB running out of memory issues after upgrade

2020-02-18 Thread Merlin Moncure
On Tue, Feb 18, 2020 at 12:10 PM Nagaraj Raj wrote: > > Below are the same configurations ins .conf file before and after updagrade > > show max_connections; = 1743 > show shared_buffers = "4057840kB" > show effective_cache_size = "8115688kB" > show maintenance_work_mem = "259MB" > show checkpoin

Re: DB running out of memory issues after upgrade

2020-02-18 Thread Nagaraj Raj
Below are the same configurations ins .conf file before and after updagrade show max_connections; = 1743show shared_buffers = "4057840kB"show effective_cache_size =  "8115688kB"show maintenance_work_mem = "259MB"show checkpoint_completion_target = "0.9"show wal_buffers = "16MB"show default_stat

Re: DB running out of memory issues after upgrade

2020-02-18 Thread Tomas Vondra
On Tue, Feb 18, 2020 at 05:46:28PM +, Nagaraj Raj wrote: after upgrade Postgres to v9.6.11 from v9.6.9 DB running out of memory issues no world load has changed before and after upgrade.  spec: RAM 16gb,4vCore Any bug reported like this or suggestions on how to fix this issue? I appreciate