[GENERAL] create index concurrently - duplicate index to reduce time without an index

Hi, We want to reindex the database behind a production service without interrupting the service. I had an idea for creating the index with a new name then dropping the existing index and renaming the new one - and it seems to work and would reduce the time without an index to be minimal. I t

Re: [GENERAL] create index concurrently - duplicate index to reduce time without an index

> From: Szymon Guz [mailto:mabew...@gmail.com] -snip- >> 2010/6/1 >> Hi, >> We want to reindex the database behind a production service without >> interrupting the service. >> I had an idea for creating the index with a new name then dropping the >> existing index and renaming the new one - a

Re: [GENERAL] create index concurrently - duplicate index to reduce time without an index

> When you have two exactly the same index definitions, that's just a > waste of resources. There will be used only one of them for speeding up > selects, but all of them must be updated during insert/update/delete > operations. Thanks Szymon, I appreciate the info. The duplication wou

Re: [GENERAL] create index concurrently - duplicate index to reduce time without an index

> -Original Message- > From: Greg Smith [mailto:g...@2ndquadrant.com] -snip- > > Gareth.Williams wrote: > > So the rest of the question is, if I have two indexes with identical > definitions, what happens? I've confirmed that I can create indexes with > ident