[HACKERS] execGrouping.c limit on work_mem

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема [HACKERS] execGrouping.c limit on work_mem
Дата
Msg-id CAMkU=1yRMzPkxhEd2EOdPakSFC2ryvEy=-akCE53nY+JezHb1Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] execGrouping.c limit on work_mem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
In BuildTupleHashTable


    /* Limit initial table size request to not more than work_mem */
    nbuckets = Min(nbuckets, (long) ((work_mem * 1024L) / entrysize));


Is this a good idea?  If the caller of this code has no respect for work_mem, they are still going to blow it out of the water.  Now we will just do a bunch of hash-table splitting in the process.  That is only going to add to the pain.

Also:

* false if it existed already.  ->additional_data in the new entry has

The field is just ->additional, not ->additional_data

Cheers,

Jeff

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: [HACKERS] simplehash.h typo
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher