Обсуждение: PK Index - Removal

Поиск
Список
Период
Сортировка

PK Index - Removal

От
Patrick B
Дата:
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

От
Adrian Klaver
Дата:
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

От
Andreas Kretschmer
Дата:
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

От
Venkata Balaji N
Дата:

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

От
Patrick B
Дата:
Cool... Thanks guys!

Index removed.

Patrick