Horton

Re: Gather performance analysis

Tomas Vondra <tomas.vondra@enterprisedb.com>

View thread View on postgr.es
From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: Robert Haas <robertmhaas@gmail.com>, Dilip Kumar <dilipbalaut@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2021-09-24T20:48:37Z
Lists: pgsql-hackers 
On 9/24/21 7:08 PM, Robert Haas wrote:
> On Fri, Sep 24, 2021 at 3:50 AM Dilip Kumar <dilipbalaut@gmail.com> wrote:
>> Tomas, can you share your test script, I would like to repeat the same
>> test in my environment and with different batching sizes.
> 
> I think it's probably the run.sh file attached to
> http://postgr.es/m/d76a759d-9240-94f5-399e-ae244e5f0285@enterprisedb.com
> 

Yep. I've used a slightly modified version, which also varies the queue 
size, but we can ignore that and the rest of the script is the same.

As for the config, I've used only slightly tuned postgresql.conf, with 
shared_buffers set to 1GB, and increased worker limits.


regards

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

Commits

  1. shm_mq: Update mq_bytes_written less often.