Re: Extremely slow intarray index creation and inserts. - Mailing list pgsql-performance

From Tom Lane
Subject Re: Extremely slow intarray index creation and inserts.
Date
Msg-id 25559.1237465526@sss.pgh.pa.us
Whole thread Raw
In response to Re: Extremely slow intarray index creation and inserts.  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: Extremely slow intarray index creation and inserts.  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-performance
Oleg Bartunov <oleg@sai.msu.su> writes:
> We usually say about 200 unique values as a limit for
> gist_int_ops.

That seems awfully small ... should we make gist_intbig_ops the default,
or more likely, raise the signature size of both opclasses?  Even at a
crossover point of 10000 I'm not sure that many real-world apps would
bother considering gist_int_ops.

            regards, tom lane

pgsql-performance by date:

Previous
From: Glyn Astill
Date:
Subject: Re: Prepared statement does not exist
Next
From: Oleg Bartunov
Date:
Subject: Re: Extremely slow intarray index creation and inserts.