puppetlabs/puppetdb — pull request #372 by grimradical (2012-12-05 00:16:03+00:00)
Title: Drop the non-GIN index on catalog_resources(tags)

The non-GIN tags index is never actually used (because nobody ever does
equality comparions on ARRAY columns). That's why we added the GIN index
in the first place, because it massively sped up tag-based queries by
actually looking inside the ARRAY column for a match.

However, I wasn't smart enough to nuke the old, non-GIN index at the
same time...this patch corrects that.

This should save people some disk space and (slightly) improve catalog
storage performance. For larger installations, the space savings could
be considerable; one user reports that old index taking close to 10GB of
disk space!

Signed-off-by: Deepak Giridharagopal