Postgres Pro
Downloads
Home   >   mailing lists

Make NUM_XLOGINSERT_LOCKS configurable - Mailing list pgsql-hackers

From
Subject Make NUM_XLOGINSERT_LOCKS configurable
Date
Msg-id 659df4e4a057d9.91303386.5a22c2cb@m0.mail.sina.com.cn
Whole thread Raw
Responses Re: Make NUM_XLOGINSERT_LOCKS configurable
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Synchronizing slots from primary to standby
Next
From: Michael Paquier
Date:
Subject: Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows