On Tue, Jun 1, 2010 at 10:00 PM, <Gareth.Williams@csiro.au> wrote:
> I'm concerned that just because I *can* create duplicate indexes, it doesn't mean I *should*.
> I'm worried it might actually break the service worse than the locking that I'm trying to avoid.
> Does anyone know which index will be used if there are duplicate ones and whether there is
> likely to be a problem?
I've done this dozens of times on a production server, midday, max
load, with no real problems. create index concurrently is one of the
greatest things anyone's ever done for pgsql.