Horton

RE: AIX support

Srirama Kucherlapati <sriram.rk@in.ibm.com>

View thread
From: Srirama Kucherlapati <sriram.rk@in.ibm.com>
To: wenhui qiu <qiuwenhuifx@gmail.com>, Heikki Linnakangas <hlinnaka@iki.fi>, "postgres-ibm-aix@wwpdl.vnet.ibm.com" <postgres-ibm-aix@wwpdl.vnet.ibm.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Cc: Robert Haas <robertmhaas@gmail.com>, Bruce Momjian <bruce@momjian.us>, Peter Eisentraut <peter@eisentraut.org>, Alvaro Herrera <alvherre@alvh.no-ip.org>, Laurenz Albe <laurenz.albe@cybertec.at>, Noah Misch <noah@leadboat.com>, Michael Paquier <michael@paquier.xyz>, Andres Freund <andres@anarazel.de>, Thomas Munro <thomas.munro@gmail.com>, "tvk1271@gmail.com" <tvk1271@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Tristan Partin <tristan@neon.tech>
Date: 2025-04-03T13:45:01Z
Lists: pgsql-hackers 
Hi Wenhui Qiu,

May I know the freeze dates.

We are nearly ready to deliver the patch. Currently, we have compiled the
source using Meson and are investigating one test case issue. Once we pinpoint
the cause, we will send you the patch. Notably, this test case behaves
differently on AIX, opting for a Bitmap Index Scan instead of an Index Scan.
Not sure if this is really specific to AIX?

                >> meson test

396 Ok:                 81
397 Expected Fail:      0
398 Fail:               1  (regex)
399 Unexpected Pass:    0
400 Skipped:            219
401 Timeout:            0


>>
  7  explain (costs off) select * from pg_proc where proname ~ '^abc';
  8 -                              QUERY PLAN
  9 -----------------------------------------------------------------------
10 - Index Scan using pg_proc_proname_args_nsp_index on pg_proc
11 -   Index Cond: ((proname >= 'abc'::text) AND (proname < 'abd'::text))
12 +                                 QUERY PLAN
13 +----------------------------------------------------------------------------
14 + Bitmap Heap Scan on pg_proc
15     Filter: (proname ~ '^abc'::text)
16 -(3 rows)
17 +   ->  Bitmap Index Scan on pg_proc_proname_args_nsp_index
18 +         Index Cond: ((proname >= 'abc'::text) AND (proname < 'abd'::text))
19 +(4 rows)

As of now below are the changes wrt to meson.

        modified:   meson.build
        modified:   src/backend/meson.build
        modified:   src/bin/initdb/initdb.c
        modified:   src/include/c.h
        modified:   src/include/port/aix.h
        modified:   src/include/utils/float.h
        modified:   src/interfaces/ecpg/compatlib/meson.build
        modified:   src/interfaces/ecpg/ecpglib/meson.build
        modified:   src/interfaces/ecpg/pgtypeslib/meson.build
        modified:   src/interfaces/libpq/meson.build
        modified:   src/test/regress/expected/txid.out
        modified:   src/test/regress/expected/xid.out
        modified:   src/test/regress/sql/sanity_check.sql



Warm regards,
Sriram.