From: | David Steele <david(at)pgmasters(dot)net> |
---|---|
To: | Beena Emerson <memissemerson(at)gmail(dot)com> |
Cc: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net>, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com> |
Subject: | Re: increasing the default WAL segment size |
Date: | 2017-04-08 14:08:35 |
Message-ID: | c333b1e2-2043-af26-5eba-bd9d2798adaa@pgmasters.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 4/7/17 2:59 AM, Beena Emerson wrote:
> 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.
This submission has been moved to CF 2017-07.
--
-David
david(at)pgmasters(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | David Steele | 2017-04-08 14:10:18 | Re: Vacuum: allow usage of more than 1GB of work mem |
Previous Message | Andres Freund | 2017-04-08 14:05:54 | Re: Running make check-world in buildfarm (was Re: [COMMITTERS] pgsql: Use SASLprep to normalize passwords for SCRAM authentication.) |