| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Rui An <rueian(dot)huang(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Many queries stuck for waiting MultiXactOffsetControlLock on PostgreSQL 9.6.1 replica |
| Date: | 2021-08-02 14:18:46 |
| Message-ID: | 1625895.1627913926@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> And you should also be prepared for the possibility that 9.6 is
> discontinued before there is a fix in which case you’d have to upgrade to
> v10 (at least) to get said fix.
If the fix is as complex as what's being discussed over at [1], there
is zero chance that it'd be back-patched at all.
Nonetheless, still being on 9.6.1 at this late date is next door to
software malpractice. There are a *lot* of known bugs in that version
that have been fixed, including performance issues [2].
regards, tom lane
[1] https://www.postgresql.org/message-id/flat/2BEC2B3F-9B61-4C1D-9FB5-5FAB0F05EF86%40yandex-team.ru
[2] https://www.postgresql.org/docs/release/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2021-08-02 15:27:38 | BUG #17129: Internal Error |
| Previous Message | Alvaro Herrera | 2021-08-02 13:08:35 | Re: BUG #17103: WAL segments are not removed after exceeding max_slot_wal_keep_size |