On Fri, Oct 17, 2008 at 11:00 PM, Віталій Тимчишин <tivv00@xxxxxxxxx> wrote:>>> 2008/10/17 Tory M Blue <tmblue@xxxxxxxxx>>>>> The real issue is my index growth and my requirement for weekly>> re-indexing (which blocks and therefore is more or less a manual>> process in a live production environment (fail over, changing vips>> etc).>> BTW: Can't you simply recreate indexes online? Since postgresql accepts> multiple indexes of same definition, this may look like:> 1) create index concurrently index_alt> 2) analyze index_alt> 3) drop index_orig> Both index_alt and index_orig having same definition Sorry for the late response. After some testing, this is in fact asolution that will and does work. It's really much simpler than doingswitch overs and taking systems down to re index. Thanks for the clue stick over the head, I know we looked into this inthe past and it was a non starter, but it seems to be working justfine!! Thanks Tory. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-performance
