RE: Re: PG 9.5.5 cores on AIX 7.1 - Mailing list pgsql-general

From Abraham, Danny
Subject RE: Re: PG 9.5.5 cores on AIX 7.1
Date
Msg-id 43f15cbdc58d4ae694f0e363f2a496f3@phx-exmbprd-01.adprod.bmc.com
Whole thread Raw
In response to Re: PG 9.5.5 cores on AIX 7.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: PG 9.5.5 cores on AIX 7.1
List 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@sss.pgh.pa.us>
Sent: Sunday, July 19, 2020 6:04 PM
To: Abraham, Danny <danny_abraham@bmc.com>
Cc: pgsql-general@postgresql.org
Subject: [EXTERNAL] Re: PG 9.5.5 cores on AIX 7.1

"Abraham, Danny" <danny_abraham@bmc.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
hadits 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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG 9.5.5 cores on AIX 7.1
Next
From: Thorsten Schöning
Date:
Subject: How to restore a dump containing CASTs into a database with a new user?