Yes, you can drop the unused index. On 11 August 2016 05:30:15 CEST, Patrick B <patrickbake...@gmail.com> wrote: >Hi guys, > >I got the following index: > >CREATE INDEX "ix_mo_pk" ON "mo" USING "btree" ((("id")::"text")) > > >The "ID" is my primary key: > >> "mo_pkey" PRIMARY KEY, "btree" ("id") > > >The ix_mo_pk index is not being used... But as it has the "ID" on it, I >wanted to ask before dropping it. > >Can you guys explain me if the ix_mo_pk is safe to delete and why? > >The mo_pkey index is being used. > >I'm using Postgres 9.2 > >Thanks >Patrick
-- Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.