Re: PK Index - Removal

[Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>]

Yes, you can drop the unused index.

On 11 August 2016 05:30:15 CEST, Patrick B <patrickbakerbr@xxxxxxxxx> 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.