Re: Need a better name for MinMax indexes

From: Darren Duncan <darren(at)darrenduncan(dot)net>
To: robert7390(at)comcast(dot)net, Josh Berkus <josh(at)agliodbs(dot)com>, "Jonathan S(dot) Katz" <jonathan(dot)katz(at)excoventures(dot)com>
Cc: PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Need a better name for MinMax indexes
Date: 2014-06-18 02:19:48
Message-ID: 53A0F744.7080303@darrenduncan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Why not simply call it "range index"? That's all a min-max pair is anyway, a
range/interval definition. Simple and easy to say. Also, I have no problem
with "minmax index" personally. I think its best to name this after what it is
rather than some non-descriptive but marketing name, or at least I really DON'T
like "big data/table index" etc. -- Darren Duncan

On 2014-06-17, 7:08 PM, robert7390(at)comcast(dot)net wrote:
> If this is going to be the start of a new type of index then maybe that's how you market it ie. part of a suite, or class, of optimized indexes.
>
> Robert Bernier
>
>
> Sent from my BlackBerry 10 smartphone.
> Original Message
> From: Josh Berkus
> Sent: Tuesday, June 17, 2014 6:17 PM
> To: Jonathan S. Katz
> Cc: PostgreSQL Advocacy
> Subject: Re: [pgsql-advocacy] Need a better name for MinMax indexes
>
> On 06/17/2014 02:43 PM, Jonathan S. Katz wrote:
>> On Jun 17, 2014, at 5:36 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>>
>>> One of the features for 9.5 will likely be "minmax" indexes, which are
>>> indexes which index only the upper and lower bounds of each data page,
>>> making for a very compact index ... like 100MB for a 100GB table.
>>>
>>> The working name for these are "minmax" indexes which is not very
>>> compelling and unlikely to reach users for how cool and useful they are.
>>> Suggestions on an alternate name?
>>
>> At the risk of sounding trite and clichéd: "big data index" or "big table index" - after all, it is an index that you want to use on a big table.
>
> Except that these likely aren't going to be the only "big data indexes"
> we ever have.
>
> Maybe "Compressed Range Indexes"? Pretty wordy, though.
>

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Vik Fearing 2014-06-19 09:40:45 Re: GSoC on WAL-logging hash indexes
Previous Message robert7390 2014-06-18 02:08:21 Re: Need a better name for MinMax indexes