Feedback-ID: id4a34324:Fastmail
Date: Thu, 18 Apr 2024 11:01:28 -0700
From: Andres Freund <andres@anarazel.de>
To: Sriram RK <sriram.rk@outlook.com>
Cc: Noah Misch <noah@leadboat.com>, Tom Lane <tgl@sss.pgh.pa.us>,
	Thomas Munro <thomas.munro@gmail.com>,
	Alvaro Herrera <alvherre@alvh.no-ip.org>,
	"pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>,
	"tvk1271@gmail.com" <tvk1271@gmail.com>
Subject: Re: AIX support
Message-ID: <20240418180128.uzzgx4r6ujgrz2eo@awork3.anarazel.de>
References: <322245.1711029459@sss.pgh.pa.us>
 <CY5PR11MB63924FAD874237BC94E6FF55FD322@CY5PR11MB6392.namprd11.prod.outlook.com>
 <CY5PR11MB6392985F305F398BE7EE9284FD3B2@CY5PR11MB6392.namprd11.prod.outlook.com>
 <20240329024832.a0@rfd.leadboat.com>
 <CA+hUKGKz=_+qbaz556kLQPcHWWF3Dys05Wn1Jnyg2weBTMJ=fg@mail.gmail.com>
 <CA+hUKG+7_ON7hd_oB6YjD4Tx23wL4E1UBSWg6C+O1brMgDB58A@mail.gmail.com>
 <3847604.1711683217@sss.pgh.pa.us>
 <CY5PR11MB63921A88005AAE45137A362DFD032@CY5PR11MB6392.namprd11.prod.outlook.com>
 <20240405172649.d1@rfd.leadboat.com>
 <CY5PR11MB63921AB0242FAAC1B522DC38FD0E2@CY5PR11MB6392.namprd11.prod.outlook.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <CY5PR11MB63921AB0242FAAC1B522DC38FD0E2@CY5PR11MB6392.namprd11.prod.outlook.com>
Archived-At: <https://www.postgresql.org/message-id/20240418180128.uzzgx4r6ujgrz2eo%40awork3.anarazel.de>
Precedence: bulk

Hi,

On 2024-04-18 11:15:43 +0000, Sriram RK wrote:
> We (IBM-AIX team) looked into this issue
>
> https://www.postgresql.org/message-id/20240225194322.a5@rfd.leadboat.com
>
> This is related to the compiler issue. The compilers xlc(13.1) and gcc(8.0)
> have issues. But we verified that this issue is resolved with the newer
> compiler versions openXL(xlc17.1) and gcc(12.0) onwards.

The reason we used these compilers was that those were the only ones we had
kinda somewhat reasonable access to, via the gcc projects'
"compile farm" https://portal.cfarm.net/
We have to rely on whatever the aix machines there provide. They're not
particularly plentiful resource-wise either.


This is generally one of the big issues with AIX support. There are other
niche-y OSs that don't have a lot of users, e.g. openbsd, but in contrast to
AIX I can just start an openbsd VM within a few minutes and iron out whatever
portability issue I'm dealing with.

Not being AIX customers we also can't raise bugs about compiler bugs, so we're
stuck doing bad workarounds.


> Also as part of the support, we will help in fixing all the issues related
> to AIX and continue to support AIX for Postgres. If we need another CI
> environment we can work to make one available. But for time being can we
> start reverting the patch that has removed AIX support.

The state when was removed was not in a state that I am OK with adding back.


> We want to make a note that postgres is used extensively in our IBM product
> and is being exploited by multiple customers.

To be blunt: Then it'd have been nice to see some investment in that before
now. Both on the code level and the infrastructure level (i.e. access to
machines etc).

Greetings,

Andres Freund