PK Index - Removal - Mailing list pgsql-general

From Patrick B
Subject PK Index - Removal
Date
Msg-id CAJNY3isMkTE5DMtg=+1hgv4ypPd-aiGZaDd=rgAZgoxPjBVsQQ@mail.gmail.com
Whole thread Raw
Responses Re: PK Index - Removal  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: PK Index - Removal  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: PK Index - Removal  (Venkata Balaji N <nag1010@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Jsonb extraction very slow
Next
From: Adrian Klaver
Date:
Subject: Re: PK Index - Removal