From: | Tory M Blue <tmblue(at)gmail(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Memory footprint diff between 9.5 and 12 |
Date: | 2020-05-07 20:33:20 |
Message-ID: | CAEaSS0a5Bi7swvgWxcLk1kBHwRjmS0KMeU5Qs-LckECDbtOWaA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | github kran | 2020-05-07 21:18:03 | Re: AutoVacuum and growing transaction XID's |
Previous Message | Eudald Valcàrcel Lacasa | 2020-05-07 19:54:44 | Re: pg_dump negation regex |