On 01/03/2017 11:07 AM, Ravi Kapoor wrote:
I have a bit strange question. I am trying to figure out how to avoid table locking while creating an index through Django (1.5.1) in Postgres 9.4.7 Django 1.5.1 does not support concurrent indexing. So my thought is to first create a concurrent index using SQL prompt. Then try to update django model to add index, which will effectively create 2 indexes on same column.
I really need to read the entire subject. So in response to my own question, yes it is on one column.
So my questions are: If I create a 2nd index on one column, 1. Does postgres scan entire table to create index from scratch or does it simply copy the first index? 2. Does postgres lock the table to create this index? thanks
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
