Re: DB running out of memory issues after upgrade

On Tue, Feb 18, 2020 at 12:10 PM Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com> 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 checkpoint_completion_target = "0.9"
> show wal_buffers = "16MB"
> show default_statistics_target = "100"
> show random_page_cost = "1.1"
> show effective_io_concurrency =" 200"
> show work_mem = "4MB"
> show min_wal_size = "256MB"
> show max_wal_size = "2GB"
> show max_worker_processes = "8"
> show max_parallel_workers_per_gather = "2"

This smells like oom killer for sure. how did you resolve some of
these values. In particular max_connections and effective_cache_size.
How much memory is in this server?

merlin