| From: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Gather performance analysis |
| Date: | 2021-09-24 20:48:37 |
| Message-ID: | 4f6f7cf8-5c3f-e5f0-1376-7b1412c6a984@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2021-09-24 20:54:40 | Re: Column Filtering in Logical Replication |
| Previous Message | Tomas Vondra | 2021-09-24 20:44:32 | Re: Gather performance analysis |