Bruno Wolff III <br...@wolff.to> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
