On Tue, Nov 20, 2018 at 8:36 AM REIX, Tony <tony.r...@atos.net> wrote: > We are trying to understand why pgbench on AIX is slower compared to > Linux/Power on the same HW/Disks. > > So, we have yet no idea about what may be the root cause and what should be > changed. > > So, changing: dynamic_shared_memory_type = sysv seems to help. > > And maybe changing the main shared memory segment could also improve the > performance. However, how one can change this?
There's no configuration setting for the main shared memory segment, but removing #define USE_ANONYMOUS_SHMEM from sysv_shmem.c would probably do the trick. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
