Home > mailing lists

Make NUM_XLOGINSERT_LOCKS configurable - Mailing list pgsql-general

From
Subject	Make NUM_XLOGINSERT_LOCKS configurable
Date	January 9 06:22:12
Msg-id	659cbbe46c16d7.00338219.ff36be34@m0.mail.sina.com.cn Whole thread Raw
List	pgsql-general

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

From: Tom Lane
Date: 08 January, 20:12:42
Subject: Re: How to \ef a function ?

From: Yi Sun
Date: 09 January, 10:38:28
Subject: postgresql custom variable in pg_settings table