Thoughts about NUM_BUFFER_PARTITIONS

Поиск
Список
Период
Сортировка
От wenhui qiu
Тема Thoughts about NUM_BUFFER_PARTITIONS
Дата
Msg-id CAGjGUAKk7tkw2en37EwPkXk1guLe=bLsrMizW-5LMLtH+12dwA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Thoughts about NUM_BUFFER_PARTITIONS  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-hackers
HI hackers
    When I read this text in this document there is a paragraph in it(https://www.interdb.jp/pg/pgsql08/03.html)
/*
The BufMappingLock is split into partitions to reduce contention in the buffer table (the default is 128 partitions). Each BufMappingLock partition guards a portion of the corresponding hash bucket slots.
*/,

Physical servers with terabytes of RAM are now commonplace,I'm looking at the comments inside the source code.I'm looking at the comments inside the source code to see if they still match the current hardware capability? The  comment says that in the future there may be a parameter,Iam a  dba now and I try to think of implementing this parameter, but I'm not a professional kernel developer, I still want the community senior developer to implement this parameter

/*
 * It's a bit odd to declare NUM_BUFFER_PARTITIONS and NUM_LOCK_PARTITIONS
 * here, but we need them to figure out offsets within MainLWLockArray, and
 * having this file include lock.h or bufmgr.h would be backwards.
 */

/* Number of partitions of the shared buffer mapping hashtable */
#define NUM_BUFFER_PARTITIONS  128

/*
 * The number of partitions for locking purposes.  This is set to match
 * NUM_BUFFER_PARTITIONS for now, on the basis that whatever's good enough for
 * the buffer pool must be good enough for any other purpose.  This could
 * become a runtime parameter in future.
 */
#define DSHASH_NUM_PARTITIONS_LOG2 7
#define DSHASH_NUM_PARTITIONS (1 << DSHASH_NUM_PARTITIONS_LOG2)

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING
Следующее
От: "Jingxian Li"
Дата:
Сообщение: Re: [PATCH] LockAcquireExtended improvement