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.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
