Adding PK using INDEX is taking time

From: Laszlo Fogas <laszlo(at)falconsocial(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Adding PK using INDEX is taking time
Date: 2015-12-02 20:03:48
Message-ID: CAOF_cTm9XzvYWsvU1n+1dkL31DW_1ouhf07fuiYo3J_6nk-TTw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Tim White 2015-12-03 00:33:41 pg_dump aborts with triggers error
Previous Message Vladimir Borodin 2015-12-02 16:48:55 Re: Major version upgrades + Replication