RE: Re: PG 9.5.5 cores on AIX 7.1

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: RE: Re: PG 9.5.5 cores on AIX 7.1
Date: 2020-07-19 18:04:22
Message-ID: 43f15cbdc58d4ae694f0e363f2a496f3@phx-exmbprd-01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Customer is using 10.4 , not 9.5.5.

Does the same argument apply for upgrading to 10.12 ?

Thanks

Danny
-----Original Message-----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Sunday, July 19, 2020 6:04 PM
To: Abraham, Danny <danny_abraham(at)bmc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: [EXTERNAL] Re: PG 9.5.5 cores on AIX 7.1

"Abraham, Danny" <danny_abraham(at)bmc(dot)com> writes:
> Slow machine, high stress.
> I think/hope that PG is the victim of an overstressed machine.
> Has anyone faced this issue in the past?

Not to point out the obvious, but you're evidently using parallel queries, which was a brand new thing in 9.5; and it had its share of teething problems. I can't say whether updating to current
(9.5.22) would fix this particular issue, but it would definitely fix a bunch of instabilities in that general area.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thorsten Schöning 2020-07-19 18:25:47 How to restore a dump containing CASTs into a database with a new user?
Previous Message Tom Lane 2020-07-19 15:04:11 Re: PG 9.5.5 cores on AIX 7.1