Make NUM_XLOGINSERT_LOCKS configurable

From: <1111hqshj(at)sina(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Make NUM_XLOGINSERT_LOCKS configurable
Date: 2024-01-10 01:37:40
Message-ID: 659df4e4a057d9.91303386.5a22c2cb@m0.mail.sina.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dear all,

I recently used benchmarksql to evaluate the performance of postgresql. I achieved nearly 20% improvement
with NUM_XLOGINSERT_LOCKS changed from 8 to 16 under some cases of high concurrency. I wonder whether
it is feasible to make NUM_XLOGINSERT_LOCKS a configuration parameter, so that users can get easier to optimize
their postgresql performance through this setting.

Thanks,
Qingsong

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2024-01-10 01:44:19 Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows
Previous Message Peter Smith 2024-01-10 01:29:21 Re: Synchronizing slots from primary to standby