Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] increasing the default WAL segment size - Mailing list pgsql-hackers

From Beena Emerson
Subject Re: [HACKERS] increasing the default WAL segment size
Date
Msg-id CAOG9ApENe-ycOFWZn3Jtq2HwzX6TWRGgTMW9gFXfUtCRH6E-kw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] increasing the default WAL segment size  (Beena Emerson <memissemerson@gmail.com>)
Responses Re: [HACKERS] increasing the default WAL segment size
List pgsql-hackers
Tree view
I ran tests and following are the details:

Machine details:
Architecture:          ppc64le
Byte Order:            Little Endian
CPU(s):                192
On-line CPU(s) list:   0-191
Thread(s) per core:    8
Core(s) per socket:    1
Socket(s):             24
NUMA node(s):          4
Model:                 IBM,8286-42A

clients>          16                      32                       64                    128
size
16MB      18895.63486     28799.48759     37855.39521     27968.88309
32MB      18313.1461      29201.44954     40733.80051     32458.74147
64 MB    18055.73141     30875.28687     42713.54447     38009.60542
128MB   18234.31424     33208.65419     48604.5593      45498.27689
256MB    19524.36498     35740.19032     54686.16898     54060.11168
512MB     20351.90719     37426.72174     55045.60719     56194.99349
1024MB   19667.67062     35696.19194     53666.60373     54353.0614

I did not get any degradation, in fact, higher values showed performance improvement for higher client count.

--

Beena Emerson

EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: [HACKERS] Duplicate assignment in Unicode/convutils.pm
Next
From: Masahiko Sawada
Date:
Subject: [HACKERS] Comment typo in publicationcmd.c