Re: PK Index - Removal
От
Adrian Klaver
Тема
Re: PK Index - Removal
Дата
Msg-id
024ebf89-d65a-7de9-a2ec-808c734a77d0@aklaver.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 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
В списке pgsql-general по дате отправления
