Re: Turning off HOT/Cleanup sometimes

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Turning off HOT/Cleanup sometimes
Дата
Msg-id CA+TgmoZKbsSzCwdO1Ab2EvFNq-NtoomLVCz8XP5Q-ZqcyYrr_g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Turning off HOT/Cleanup sometimes  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
On Thu, Mar 12, 2015 at 3:48 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
> On 3/12/15 5:41 AM, Andres Freund wrote:
>> 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.
>
> I didn't mean to put words in your mouth.  I just wanted to summarize
> the thread as, Andres wanted more fine-tuning on the behavior, Robert
> expressed serious doubts that that will lead to an acceptable result.

Or to put that another way, I'm not sure there's one behavior here
that will please everybody.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: OOM-killer issue when updating a inheritance table which has large number of child tables
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Reduce pinning in btree indexes