Re: Build or update inarray GIST index very slow. - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: Build or update inarray GIST index very slow.
Date
Msg-id CAMkU=1xA4G9sQyo3iOim798u=_AFo_ct+8pU+JrAPGxazoAWQw@mail.gmail.com
Whole thread Raw
In response to Build or update inarray GIST index very slow.  (Valery Komarov <komarov@valerka.net>)
List pgsql-bugs
On Fri, Mar 9, 2018 at 1:53 PM, Valery Komarov <komarov@valerka.net> wrote:
Build or update inarray GIST index very very  slow.


Yes, it is. I think there is room for improvement for the algorithm for picking the pivot.

But in documentation "As a rule of thumb, a GIN index is faster to search than a GiST index, but slower to build or update; so GIN is better suited for static data and GiST for often-updated data."

Rules of thumb are not always true, that is what makes them rules of thumb.
 
Also, note that that sentence was removed from the documentation in 9.5 onward (commit 8e1ad1b37c7afdf99).  I can't find the mailing-list thread discussing it, but I think that that advice was deemed too vague to be useful.

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Kouber Saparev
Date:
Subject: Re: Unrecognized exception condition "deprecated_feature"
Next
From: Tom Lane
Date:
Subject: Re: Unrecognized exception condition "deprecated_feature"