Make NUM_XLOGINSERT_LOCKS configurable

From: <1111hqshj(at)sina(dot)com>
To: "pgsql-general" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Make NUM_XLOGINSERT_LOCKS configurable
Date: 2024-01-09 03:22:12
Message-ID: 659cbbe46c16d7.00338219.ff36be34@m0.mail.sina.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,
I recently used benchmarksql to evaluate the performance of postgresql. I achievednearly 20% improvement with NUM_XLOGINSERT_LOCKS changed from 8 to 16under some cases of high concurrency. 
I wonder whether it is feasible to make NUM_XLOGINSERT_LOCKS a configurationparameter, so that users can get easier to optimize their postgresql performancethrough this setting.
Thanks,Qingsong

Browse pgsql-general by date

  From Date Subject
Next Message Yi Sun 2024-01-09 07:38:28 postgresql custom variable in pg_settings table
Previous Message Joe Conway 2024-01-08 20:40:23 Re: Emitting JSON to file using COPY TO