Re: [RFC] Minmax indexes

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [RFC] Minmax indexes
Дата
Msg-id 51BF5B42.70200@agliodbs.com
обсуждение исходный текст
Ответ на [RFC] Minmax indexes  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
> So there isn't a "fall down" thing here. We expect the recently
> loaded/updated data to be scanned and that's OK.
> 
> Having the minmax index updated greedily is just adding extra work for
> fast diminishing returns. We can always add that later if really
> needed, but I doubt it will be needed - in just the same way as mat
> views aren't greedily updated.

Ok, in that case, can we add the patch without messing with the FSM
logic?  It'll work out-of-the-box for append-only tables, and that's a
pretty solid use case.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



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

Предыдущее
От: Sawada Masahiko
Дата:
Сообщение: Re: Patch for fail-back without fresh backup
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: refresh materialized view concurrently