Re: PK Index - Removal
От
Venkata Balaji N
Тема
Re: PK Index - Removal
Дата
Msg-id
CAEyp7J-mzj2iw6KWVBEeywdie3HppE-annJskN+jb6s6HJV6ZQ@mail.gmail.com
Ответ на
PK Index - Removal (Patrick B)
Список
Дерево обсуждения
PK Index - Removal Patrick B <patrickbakerbr@gmail.com>
Re: PK Index - Removal Adrian Klaver <adrian.klaver@aklaver.com>
Re: PK Index - Removal Venkata Balaji N <nag1010@gmail.com>
Re: PK Index - Removal Patrick B <patrickbakerbr@gmail.com>
Re: PK Index - Removal Andreas Kretschmer <andreas@a-kretschmer.de>
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
В списке pgsql-general по дате отправления
