Re: Concurrent Reindex on Primary Key for large table

From: rverghese <riyav(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Concurrent Reindex on Primary Key for large table
Date: 2012-02-22 21:07:20
Message-ID: 1329944840460-5506261.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi
I had another question, what about when the primary key is a foreign key in
another table? Is the only option to drop the FK and recreate it after the
primary key has been created with the new index?

Thanks!
RV

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Concurrent-Reindex-on-Primary-Key-for-large-table-tp5467243p5506261.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2012-02-23 09:14:32 Re: How to split up phone numbers?
Previous Message Adrian Klaver 2012-02-22 15:32:10 Re: on insert rule with default value