Home > mailing lists

Adding PK using INDEX is taking time - Mailing list pgsql-admin

From	Laszlo Fogas
Subject	Adding PK using INDEX is taking time
Date	December 2, 2015 23:03:52
Msg-id	CAOF_cTm9XzvYWsvU1n+1dkL31DW_1ouhf07fuiYo3J_6nk-TTw@mail.gmail.com Whole thread Raw
List	pgsql-admin

hello guys,

anyone experienced that

ADD CONSTRAINT xx PRIMARY KEY USING INDEX

is not returning immediately?

I'm pointing it to a nice UNIQUE index, it has all locks acquired, but reads the disk heavily. Then i killed it, since queries started to pile up.

Laszlo

From: Vladimir Borodin
Date: 02 December 2015, 19:49:07
Subject: Re: Major version upgrades + Replication

From: Tim White
Date: 03 December 2015, 03:33:45
Subject: pg_dump aborts with triggers error