Postgres Pro
Downloads
Home   >   mailing lists

Memory footprint diff between 9.5 and 12 - Mailing list pgsql-general

From Tory M Blue
Subject Memory footprint diff between 9.5 and 12
Date
Msg-id CAEaSS0a5Bi7swvgWxcLk1kBHwRjmS0KMeU5Qs-LckECDbtOWaA@mail.gmail.com
Whole thread Raw
Responses Re: Memory footprint diff between 9.5 and 12  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Re: Memory footprint diff between 9.5 and 12  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
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
Tory

pgsql-general by date:

Previous
From: Eudald Valcàrcel Lacasa
Date:
Subject: Re: pg_dump negation regex
Next
From: github kran
Date:
Subject: Re: AutoVacuum and growing transaction XID's