RE: Shared Memory: How to use SYSV rather than MMAP ?

Tony De : Alvaro Herrera Envoyé : jeudi 26 septembre 2019 21:22 À : Thomas Munro Cc : REIX, Tony ; Andres Freund ; Robert Haas ; Pg Hackers ; EMPEREUR-MOT, SYLVIE Objet : Re: Shared Memory: How to use SYSV rather than MMAP ? On 2019-Sep-10, Thomas Munro wrote: > Here&#

RE: Shared Memory: How to use SYSV rather than MMAP ?

2019 14:39 À : REIX, Tony Cc : Thomas Munro ; Andres Freund ; Robert Haas ; Pg Hackers ; EMPEREUR-MOT, SYLVIE Objet : Re: Shared Memory: How to use SYSV rather than MMAP ? Hi Tony, On 2019-Sep-27, REIX, Tony wrote: > Hello Thomas, Alvaro, > > Sorry for the late answer, I missed your m

RE: Shared Memory: How to use SYSV rather than MMAP ?

le is used when testing. Trying now to rebuild and hope tests will be launched this time. Regards, Tony De : Thomas Munro Envoyé : mardi 10 septembre 2019 00:57 À : Alvaro Herrera Cc : REIX, Tony ; Andres Freund ; Robert Haas ; Pg Hackers ; EMPEREUR-MOT, SYL

RE:[HACKERS] Deadlock in XLogInsert at AIX

Hi Michael, My team and my company (ATOS/Bull) are involved in improving the quality of PostgreSQL on AIX. We have AIX 6.1, 7.1, and 7.2 Power8 systems, with several logical/physical processors. And I plan to have a more powerful (more processors) machine for running PostgreSQL stress tests. A

RE:[HACKERS] Deadlock in XLogInsert at AIX

Hi Michael You said: > Setting up a buildfarm member with the combination of compiler and > environment where you are seeing the failures would be the best answer > in my opinion: > https://wiki.postgresql.org/wiki/PostgreSQL_Buildfarm_Howto > > This does not require special knowledge of Postgre

RE:[HACKERS] Deadlock in XLogInsert at AIX

lles - France www.atos.net De : Noah Misch [n...@leadboat.com] Envoyé : mardi 16 janvier 2018 17:19 À : REIX, Tony Cc : Michael Paquier; Heikki Linnakangas; Konstantin Knizhnik; PostgreSQL Hackers; Bernd Helmle; OLIVA, PASCAL; EMPEREUR-MOT, SYLVIE Objet

Issue with v11.0 within jsonb_plperl tests in 32bit on AIX

Hi, I'm building PostgreSQL v11.0 on AIX (6.1, 7.1, & 7.2). The 2 new tests jsonb_plperl fail in 32bit, not in 64bit. All other tests are OK. - Same issue for all 3 versions of AIX - Version of Perl : 5.24.0 - Version of Python: 2.7.12 I have traced details, but it is still uncle

RE: Issue with v11.0 within jsonb_plperl tests in 32bit on AIX

ader Office : +33 (0) 4 76 29 72 67 1 rue de Provence - 38432 Échirolles - France www.atos.net<https://mail.ad.bull.net/owa/redir.aspx?C=PvphmPvCZkGrAgHVnWGsdMcDKgzl_dEIsM6rX0g4u4v8V81YffzBGkWrtQeAXNovd3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> ____ D

RE: Issue with v11.0 within jsonb_plperl tests in 32bit on AIX

0') - '0') & 0x3F) << 12) + '0') - '0') & 0x3F) << 18) + '0') - '0') & 0x3F) << 24))), (errmsg("cannot transform this Perl type to jsonb"))); if (__builtin_constant_p(20) && (20) >= 20)

Shared Memory: How to use SYSV rather than MMAP ?

Hi, On AIX, since with MMAP we have only 4K pages though we can have 64K pages with SYSV, we'd like to experiment with SYSV rather than MMAP and measure the impact to the performance. Looking at file: src/include/storage/dsm_impl.h , it seemed to me that replacing the line: #define DEFAULT_

RE: Shared Memory: How to use SYSV rather than MMAP ?

ance www.atos.net<https://mail.ad.bull.net/owa/redir.aspx?C=PvphmPvCZkGrAgHVnWGsdMcDKgzl_dEIsM6rX0g4u4v8V81YffzBGkWrtQeAXNovd3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : Robert Haas Envoyé : mardi 20 novembre 2018 13:53:53 À : REIX, Tony Cc : pgsql-hack...@

RE: Shared Memory: How to use SYSV rather than MMAP ?

novembre 2018 15:53:11 À : REIX, Tony Cc : pgsql-hack...@postgresql.org; EMPEREUR-MOT, SYLVIE Objet : Re: Shared Memory: How to use SYSV rather than MMAP ? On Tue, Nov 20, 2018 at 8:36 AM REIX, Tony wrote: > We are trying to understand why pgbench on AIX is slower compared to > Linux/Power on

RE: Shared Memory: How to use SYSV rather than MMAP ?

Hi Thomas, Andres, I still have to reread/study in depth the discussion in this thread in order to understand all these information. However, we've already got a very good performance improvement of pgbench on AIX 7.2 / Power9 with that change: + ~38% in best case. See below for the details.

RE: Shared Memory: How to use SYSV rather than MMAP ?

fwww.atos.net%2f> ________ De : REIX, Tony Envoyé : mercredi 21 novembre 2018 09:45:12 À : Thomas Munro; Andres Freund Cc : Robert Haas; Pg Hackers; EMPEREUR-MOT, SYLVIE; BERGAMINI, DAMIEN Objet : RE: Shared Memory: How to use SYSV rather than MMAP ? Hi Thomas, Andres, I still h

RE: Shared Memory: How to use SYSV rather than MMAP ?

ttps://mail.ad.bull.net/owa/redir.aspx?C=PvphmPvCZkGrAgHVnWGsdMcDKgzl_dEIsM6rX0g4u4v8V81YffzBGkWrtQeAXNovd3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : Thomas Munro Envoyé : vendredi 23 novembre 2018 22:07:23 À : REIX, Tony Cc : Andres Freund; Robert Ha

RE: Shared Memory: How to use SYSV rather than MMAP ?

Hi Thomas, You said: I think we should respect the huge_pages GUC, as we do on Linux and Windows (since there are downsides to using large pages, maybe not everyone would want that). It could even be useful to allow different page sizes to be requested by GUC (I see that DB2 has an option to u

AIX: Symbols are missing in libpq.a

Hi, While porting postgresql-odbc v13 to AIX, we have found that (at least) 2 symbols are missing in libpq.a provided by the port of PostgreSQL v13.1 to AIX 7.1 by the BullFreeware project : pg_char_to_encoding pg_encoding_to_char Looking at details, it appears that these symbols are present i

RE: AIX: Symbols are missing in libpq.a

JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : Noah Misch Envoyé : dimanche 29 août 2021 17:46 À : REIX, Tony Cc : pgsql-hackers@lists.postgresql.org Objet : Re: AIX: Symbols are missing in libpq.a Caution! External email. Do not open attachments or click links, unles

RE: AIX: Symbols are missing in libpq.a

ciate some example. I'm asking my colleague too if he can help me here. Thx Tony De : Noah Misch Envoyé : lundi 30 août 2021 16:52 À : REIX, Tony Cc : pgsql-hackers@lists.postgresql.org Objet : Re: AIX: Symbols are missing in libpq.a Caution! External ema

RE: AIX: Symbols are missing in libpq.a

l.net/owa/redir.aspx?C=PvphmPvCZkGrAgHVnWGsdMcDKgzl_dEIsM6rX0g4u4v8V81YffzBGkWrtQeAXNovd3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : Noah Misch Envoyé : mardi 31 août 2021 05:33 À : REIX, Tony Cc : pgsql-hackers@lists.postgresql.org ; CHIGOT, CLEMENT Objet : Re: AIX: Symbols are missing in libpq.a Ca

RE: AIX: Symbols are missing in libpq.a

.aspx?C=PvphmPvCZkGrAgHVnWGsdMcDKgzl_dEIsM6rX0g4u4v8V81YffzBGkWrtQeAXNovd3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : Noah Misch Envoyé : vendredi 3 septembre 2021 04:58 À : REIX, Tony Cc : pgsql-hackers@lists.postgresql.org ; CHIGOT, CLEMENT Objet : Re: AI

RE: Shared Memory: How to use SYSV rather than MMAP ?

ovd3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : Thomas Munro Envoyé : vendredi 1 février 2019 14:49:01 À : REIX, Tony Cc : Andres Freund; Robert Haas; Pg Hackers; EMPEREUR-MOT, SYLVIE Objet : Re: Shared Memory: How to use SYSV rather than MMAP ? Bonjour Tony, On Sat, Jan 5,

RE: Shared Memory: How to use SYSV rather than MMAP ?

d3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : Thomas Munro Envoyé : jeudi 7 février 2019 03:30 À : REIX, Tony Cc : EMPEREUR-MOT, SYLVIE Objet : Re: Shared Memory: How to use SYSV rather than MMAP ? On Thu, Feb 7, 2019 at 4:08 AM REIX, Tony wrote: > I&#

RE: Shared Memory: How to use SYSV rather than MMAP ?

8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> ____ De : REIX, Tony Envoyé : lundi 26 novembre 2018 18:00:15 À : Thomas Munro Cc : Andres Freund; Robert Haas; Pg Hackers; EMPEREUR-MOT, SYLVIE; BERGAMINI, DAMIEN Objet : RE: Shared Memory: How to use SYSV rather than MMAP ?

RE: Shared Memory: How to use SYSV rather than MMAP ?

www.atos.net<https://mail.ad.bull.net/owa/redir.aspx?C=PvphmPvCZkGrAgHVnWGsdMcDKgzl_dEIsM6rX0g4u4v8V81YffzBGkWrtQeAXNovd3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : Thomas Munro Envoyé : mercredi 26 décembre 2018 00:28:54 À : REIX, Tony Cc : Andres Fr

PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

Hi, 64bit: all tests are OK. 32bit: 2 failures: == running regression test queries == test jsonb_plperl ... FAILED test jsonb_plperlu ... FAILED Expected/Result logs attached to this email. Perl 5.24.0 . Any idea? What about tests on Linux on i686 ? Regards, C

RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

& Technical Leader Office : +33 (0) 4 76 29 72 67 1 rue de Provence - 38432 Échirolles - France www.atos.net De : Michael Paquier [mich...@paquier.xyz] Envoyé : mercredi 30 mai 2018 22:25 À : Tom Lane Cc : Alvaro Herrera; REIX, Tony; PostgreSQL-development

RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

varo Herrera [alvhe...@2ndquadrant.com] Envoyé : mercredi 30 mai 2018 20:46 À : REIX, Tony Cc : PostgreSQL-development; APEKE, SENA (ext); Peter Eisentraut; Anthony Bykov Objet : Re: PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode On 2018-May-30, REIX, Tony wrote: > 32bit: 2 f

RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

Reix ATOS / Bull SAS ATOS Expert IBM Coop Architect & Technical Leader Office : +33 (0) 4 76 29 72 67 1 rue de Provence - 38432 Échirolles - France www.atos.net De : Tom Lane [t...@sss.pgh.pa.us] Envoyé : mercredi 30 mai 2018 21:36 À : Alvaro Herrera C

RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

) 4 76 29 72 67 1 rue de Provence - 38432 Échirolles - France www.atos.net De : Tom Lane [t...@sss.pgh.pa.us] Envoyé : jeudi 31 mai 2018 15:35 À : REIX, Tony Cc : Alvaro Herrera; PostgreSQL-development; APEKE, SENA (ext); Peter Eisentraut; Anthony Bykov Objet : Re

RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

.net De : Tom Lane [t...@sss.pgh.pa.us] Envoyé : jeudi 31 mai 2018 16:28 À : REIX, Tony Cc : Alvaro Herrera; PostgreSQL-development; APEKE, SENA (ext); Peter Eisentraut; Anthony Bykov; Noah Misch Objet : Re: PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode "REIX, Tony

RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

e de Provence - 38432 Échirolles - France www.atos.net De : Tom Lane [t...@sss.pgh.pa.us] Envoyé : mercredi 30 mai 2018 21:36 À : Alvaro Herrera Cc : REIX, Tony; PostgreSQL-development; APEKE, SENA (ext); Peter Eisentraut; Anthony Bykov Objet : Re: PostgreSQ

RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

De : Tom Lane [t...@sss.pgh.pa.us] Envoyé : vendredi 1 juin 2018 01:23 À : Noah Misch Cc : REIX, Tony; Alvaro Herrera; PostgreSQL-development; APEKE, SENA (ext); Peter Eisentraut; Anthony Bykov Objet : Re: PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mod

PostgreSLQ v10.1 and xlC compiler on AIX

Hi, We are porting PostgreSQL v10.1 on AIX (7.2 for now). And we have several tests failures, in 32bit and 64bit. We are using xlc 13.01.0003.0003 with -O2. Tests were 100% OK with version 9.6.2 . About 32 bit failures within v10.1, we have 3 failures including: create_aggregate ...

RE:PostgreSLQ v10.1 and xlC compiler on AIX

nical Leader Office : +33 (0) 4 76 29 72 67 1 rue de Provence - 38432 Échirolles - France www.atos.net De : Michael Paquier [michael.paqu...@gmail.com] Envoyé : jeudi 23 novembre 2017 14:08 À : REIX, Tony Cc : PostgreSQL Hackers; OLIVA, PASCAL Objet : Re: Po

RE: impact of SPECTRE and MELTDOWN patches

Hi, Which HW have you experimented with? Thx/Regards Cordialement, Tony Reix tony.r...@atos.net ATOS / Bull SAS ATOS Expert IBM Coop Architect & Technical Leader Office : +33 (0) 4 76 29 72 67 1 rue de Provence - 38432 Échirolles - France www.atos.net

RE: impact of SPECTRE and MELTDOWN patches

t;https://mail.ad.bull.net/owa/redir.aspx?C=PvphmPvCZkGrAgHVnWGsdMcDKgzl_dEIsM6rX0g4u4v8V81YffzBGkWrtQeAXNovd3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : ROS Didier Envoyé : vendredi 21 septembre 2018 11:40:15 À : REIX, Tony; pgsql-hack...@postgresql.org Objet :

RE: impact of SPECTRE and MELTDOWN patches

net<https://mail.ad.bull.net/owa/redir.aspx?C=PvphmPvCZkGrAgHVnWGsdMcDKgzl_dEIsM6rX0g4u4v8V81YffzBGkWrtQeAXNovd3ttkJL8JIc.&URL=http%3a%2f%2fwww.atos.net%2f> De : ROS Didier Envoyé : vendredi 21 septembre 2018 11:52:42 À : REIX, Tony; pgsql-hack...@postgresql.org Ob