Search Postgresql Archives

PK Index - Removal

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux