Creating an index on a live database

From: John McCawley <nospam(at)hardgeus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Creating an index on a live database
Date: 2007-02-06 17:38:04
Message-ID: 45C8BCFC.3050108@hardgeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table with a few million rows which has inserts performed on it
roughly 50 or so times a minute. It contains a heavily-queried column
that I would like to add an index to, but I am concerned about a
deadlock occurring. Should I wait until downtime to add the index, or
is the Postgres add index command "nice" enough to avoid deadlocks?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2007-02-06 17:47:15 Re: pg_restore single table privileges/indexes
Previous Message Jeff Amiel 2007-02-06 17:32:52 pg_restore single table privileges/indexes