Re: increasing the default WAL segment size

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

In response to

Browse pgsql-hackers by date

  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.)