Re: Regression test fails when BLCKSZ is 1kB

Поиск
Список
Период
Сортировка
От Zdenek Kotala
Тема Re: Regression test fails when BLCKSZ is 1kB
Дата
Msg-id 480DAC3A.5010409@sun.com
обсуждение исходный текст
Ответ на Re: Regression test fails when BLCKSZ is 1kB  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Regression test fails when BLCKSZ is 1kB  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane napsal(a):

> Another possible answer is to change the minimum to be just 64K always.
> I'm not certain that it's really sensible to tie the minimum work_mem to
> BLCKSZ --- I don't think we do anything where work_mem is controlling a
> pool of page buffers, do we?

Yeah, I try to find all usage and it seems everything is related to tuplestore, 
Bitmap or Hash join. I think we can set 64K set limit without any problem.

By the way is any reason to have work_mem * 1024 "everywhere" when we have unit 
support in GUC?

    Zdenek


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

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: Regression test fails when BLCKSZ is 1kB
Следующее
От: PFC
Дата:
Сообщение: Per-table random_page_cost for tables that we know are always cached