On 13 Oct 2010, at 24:03, sunpeng wrote: > Hi, I have the following table: > CREATE TABLE A > ( > a1 integer not null, > a2 integer, > a3 integer, > a4 integer > ) > and have the following four indices: > create index ind_a1 on A USING gist(a1); > create index ind_a2 on A USING gist(a2); > create index ind_a3 on A USING gist(a3); > create index ind_a4 on A USING gist(a4);
Is there any reason you're using gist indices on integer fields? Those are primarily used with full-text searching, I wouldn't expect them to be particularly efficient for scalar values. A (default) btree would probably perform better. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4cb55736678302085914008! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
