Re: Turning off HOT/Cleanup sometimes

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Turning off HOT/Cleanup sometimes
Дата
Msg-id 20140110012822.GS2686@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Turning off HOT/Cleanup sometimes  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> So when somebody says "relying on vacuum instead of doing
> HOT pruning" what I hear is "flush performance down the toilet"... but
> of course the real way to resolve this is to test whatever patch Simon
> or someone else eventually posts, not to speculate without data.

I don't think anyone was seriously proposing that (certainly not with
today's VACUUM).  What I've heard speculated about is doing HOT pruning
during UPDATE and/or INSERT but specifically not during SELECT.  I
concur that we need data to really understand the difference, hopefully
there'll be a patch posted which we can play with.
Thanks,
    Stephen

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

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: Disallow arrays with non-standard lower bounds
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: Display oprcode and its volatility in \do+