Re: Turning off HOT/Cleanup sometimes

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Turning off HOT/Cleanup sometimes
Дата
Msg-id 20150312094108.GA20199@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: Turning off HOT/Cleanup sometimes  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Turning off HOT/Cleanup sometimes  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
On 2015-03-11 20:55:18 -0400, Peter Eisentraut wrote:
> I don't think so.  Andres basically wanted a nontrival algorithm to
> determine how much pruning to do during a read-only scan.  And Robert
> basically said, that's not really possible.

I don't think either of us made really strong statements.

> We have seen some benchmarks that show significant improvements.  We
> have seen some (constructed ones) that show problems.

FWIW, it's not that constructed. It's just a mixture of read with write
load.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: EvalPlanQual behaves oddly for FDW queries involving system columns
Следующее
От: Jozef Mlich
Дата:
Сообщение: shebang for tcl postgresql modules