search

darold / pgcluu

PostgreSQL Cluster performances monitoring and auditing tool
http://pgcluu.darold.net/
PostgreSQL License
336 stars 45 forks source link

Redundant index should be the same type #161

Closed Krysztophe closed 8 months ago

Krysztophe commented 1 year ago

pgcluu detected these indexes as redundant:

CREATE INDEX gist_idx_aide_code ON public.aide USING gist (code public.gist_trgm_ops) 
CREATE UNIQUE INDEX aide_code_key ON public.aide USING btree (code)

If one is a gist, the other one a btree, I suppose that they are NOT redundant.

darold commented 8 months ago

Commit f7f1e9e fix that.

Krysztophe commented 8 months ago

Merci !