Re: Extremely slow intarray index creation and inserts.

From: Tom Lane
Subject: Re: Extremely slow intarray index creation and inserts.
Date: ,
Msg-id: 25559.1237465526@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: Extremely slow intarray index creation and inserts.  (Oleg Bartunov)
Responses: Re: Extremely slow intarray index creation and inserts.  (Oleg Bartunov)
List: pgsql-performance


Oleg Bartunov <> 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:

From: Bruce Momjian
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4
From: Anne Rosset
Date:
Subject: Need help with one query