I have a table with this definition:
CREATE TABLE public.delete_operation ( id bigint NOT NULL, parent_id bigint, pdu character varying, progress smallint NOT NULL DEFAULT 0, description character varying, state character varying(31) NOT NULL, status character(1) NOT NULL DEFAULT 'A'::bpchar, CONSTRAINT delete_operation_pkey PRIMARY KEY (id), CONSTRAINT "Ref_delete_operation_to_delete_operation" FOREIGN KEY (parent_id) REFERENCES public.delete_operation (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION )
Index on id created implicitly.
Then I want to create an index on
parent_id (which refers to same id column with already created index).
My question is: would it be physically same index with different names or will it double this index ?