Re: Fast insertion indexes: why no developments

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Fast insertion indexes: why no developments
Дата
Msg-id CAGTBQpYbc5MGFzjbFx9QcfcVuiw-AeyqDnO0QtStapK27ebPkQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fast insertion indexes: why no developments  (Leonardo Francalanci <m_lists@yahoo.it>)
Ответы Re: Fast insertion indexes: why no developments  (Leonardo Francalanci <m_lists@yahoo.it>)
Re: Fast insertion indexes: why no developments  (Greg Stark <stark@mit.edu>)
Список pgsql-hackers
On Tue, Nov 5, 2013 at 12:22 PM, Leonardo Francalanci <m_lists@yahoo.it> wrote:
> Claudio Freire wrote
>> you haven't really
>> analyzed update cost, which is what we were talking about in that last
>> post.
>
> I don't care for a better update cost if the cost to query is a table scan.
> Otherwise, I'll just claim that no index at all is even better than minmax:
> 0 update cost, pretty much same query time.
>
> Maybe there's value in minmax indexes for sequential data, but not for
> random data, which is the topic of this thread.


Well, of course, they're not magic pixie dust.

But is your data really random? (or normal?)

That's the thing...



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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: [PATCH] configure: add git describe output to PG_VERSION when building a git tree
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: GIN improvements part 1: additional information