Postgres Pro
Downloads
Home   >   mailing lists

Thread: PK Index - Removal

PK Index - Removal

From
Patrick B
Date:
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

Re: PK Index - Removal

From
Adrian Klaver
Date:
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.klaver@aklaver.com

Re: PK Index - Removal

From
Andreas Kretschmer
Date:
Yes, you can drop the unused index.

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

Re: PK Index - Removal

From
Venkata Balaji N
Date:

On Thu, Aug 11, 2016 at 1:30 PM, Patrick B <patrickbakerbr@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.

Yes, you can drop the unused Indexes provided they are not the ones created by primary key or unique key constraints. By your explanation, it seems that the index "ix_mo_pk" is an user defined index (created by you), so, it can be dropped if not used.

Regards,
Venkata B N

Fujitsu Australia

Re: PK Index - Removal

From
Patrick B
Date:
Cool... Thanks guys!

Index removed.

Patrick