Message-ID: <c1004775-977e-4645-aeef-1e37843d2f2b@postgrespro.ru>
Date: Mon, 16 Oct 2023 11:04:25 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Some performance degradation in REL_16 vs REL_15
Content-Language: en-US
To: Andres Freund <andres@anarazel.de>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>,
 David Rowley <dgrowleyml@gmail.com>, Michael Paquier <michael@paquier.xyz>
References: <79e2f903-8bb0-4fc9-840c-f30d878d2327@postgrespro.ru>
 <20231013020522.ljwsw7mkpf23dylq@awork3.anarazel.de>
From: "Anton A. Melnikov" <a.melnikov@postgrespro.ru>
In-Reply-To: <20231013020522.ljwsw7mkpf23dylq@awork3.anarazel.de>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/c1004775-977e-4645-aeef-1e37843d2f2b%40postgrespro.ru>
Precedence: bulk

On 13.10.2023 05:05, Andres Freund wrote:
> Could you provide a bit more details about how you ran the benchmark?  The
> reason I am asking is that ~330 TPS is pretty slow for -c20.  Even on spinning
> rust and using the default settings, I get considerably higher results.
> 
> Oh - I do get results closer to yours if I use pgbench scale 1, causing a lot
> of row level contention. What scale did you use?


I use default scale of 1.
And run the command sequence:
$pgbench -i bench
$sleep 1
$pgbench -c20 -T10 -j8
in a loop to get similar initial conditions for every "pgbench -c20 -T10 -j8" run.

Thanks for your interest!

With the best wishes,

-- 
Anton A. Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company