Re: PK Index - Removal

On 08/10/2016 08:30 PM, Patrick B 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?

To be sure it would be nice to see from psql:

\d+ mo

>
> The mo_pkey index is being used.
>
> I'm using Postgres 9.2
>
> Thanks
> Patrick

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com