Re: Minmax indexes

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Minmax indexes
Дата
Msg-id 20140709231352.GT6390@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Minmax indexes  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Minmax indexes  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Josh Berkus wrote:
> On 07/09/2014 02:16 PM, Alvaro Herrera wrote:
> > The way it works now, each opclass needs to have three support
> > procedures; I've called them getOpers, maybeUpdateValues, and compare.
> > (I realize these names are pretty bad, and will be changing them.)
> 
> I kind of like "maybeUpdateValues".  Very ... NoSQL-ish.  "Maybe update
> the values, maybe not."  ;-)

:-)  Well, that's exactly what happens.  If we insert a new tuple into
the table, and the existing summarizing tuple (to use Peter's term)
already covers it, then we don't need to update the index tuple at all.
What this name doesn't say is what values are to be maybe-updated.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: IMPORT FOREIGN SCHEMA statement
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Minmax indexes