Bruno Wolff III <bruno@xxxxxxxx> writes: > ... I create both a normal gist index and an exclude index using the > following: > CREATE INDEX contains ON iplocation USING gist (network inet_ops); > ALTER TABLE iplocation > ADD CONSTRAINT overlap EXCLUDE USING gist (network inet_ops WITH &&); > But I am wondering if it is useful to have the normal gist index for > finding netblocks containing a specific IP address, as it seems like the > exclude index should be usable for that as well. No, that manually-created index is completely redundant with the constraint index. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
