Re: Memory footprint diff between 9.5 and 12

From: Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Memory footprint diff between 9.5 and 12
Date: 2020-05-07 22:03:48
Message-ID: 3ce4589dae05ec0f3308b0fb86f7a8a895e7b753.camel@lists.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2020-05-07 at 13:33 -0700, Tory M Blue wrote:
> I hadn't noticed this until today, but a running 9.5 system with
> buffers at 10GB starts and has been running years without issues.
> (15GB available)
> Postgres 12 will not start with that configuration, complaining about
> memory availability. So Postgres12 won't start until shared buffers
> is 6GB, but even with that, my DB servers , postgres queries started
> complaining about being unable to allocate memory "unable to
> allocate".
>
> So dropping them to 4GB (on a 15GB system), may help, but did I miss a
> huge note about significant memory changes between 9.5 to 12?
>
> Is there something else I'm missing that on busy systems is important,
> something introduced in 10 or 11 as again I'm not seeing anything
> noted in 12.
> Thanks

Is this running on an otherwise identical system? Or do you have a
different kernel, overcommit settings, or swap configuration?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Rowley 2020-05-07 23:46:00 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )
Previous Message David G. Johnston 2020-05-07 21:59:43 Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )