Re: SET work_mem = '1TB';

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: SET work_mem = '1TB';
Дата
Msg-id CAMkU=1yQymPj_=2HA_qwiOhf40fGFGehBQXq_8+yxdHrgQCzWQ@mail.gmail.com
обсуждение исходный текст
Ответ на SET work_mem = '1TB';  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: SET work_mem = '1TB';  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
On Tuesday, May 21, 2013, Simon Riggs wrote:
I worked up a small patch to support Terabyte setting for memory.
Which is OK, but it only works for 1TB, not for 2TB or above.

I've incorporated my review into a new version, attached.

Added "TB" to the docs, added the macro KB_PER_TB, and made "show" to print "1TB" rather than "1024GB".

I tested several of the memory settings to see that it can be set and retrieved.  I haven't tested actual execution as I don't have that kind of RAM.

I don't see how it could have a performance impact, it passes make check etc., and I don't think it warrants a new regression test.

I'll set it to ready for committer.

Cheers,

Jeff
Вложения

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: spurious wrap-around shutdown
Следующее
От: Ian Link
Дата:
Сообщение: Patch for fast gin cache performance improvement