Home > mailing lists

Re: script to drop and build all indexes in database - Mailing list pgsql-admin

From	bricklen
Subject	Re: script to drop and build all indexes in database
Date	December 14, 2013 02:05:26
Msg-id	CAGrpgQ_yN3FDPFNXfB1sicj2TLwWvNxyFGTvDNV35R1FiYcOvg@mail.gmail.com Whole thread Raw
In response to	script to drop and build all indexes in database ("Campbell, Lance" <lance@illinois.edu>)
List	pgsql-admin

On Fri, Dec 13, 2013 at 1:55 PM, Campbell, Lance <lance@illinois.edu> wrote:

Suggestion:
It seems like it would be a good idea to add the parameter of concurrently to reindex.

There have been threads (and patches) for this topic going back a year IIRC. Here is the most recent one a quick search turned up: http://www.postgresql.org/message-id/20131118121958.GB20305@awork2.anarazel.de

From: Kevin Grittner
Date: 14 December 2013, 01:31:51
Subject: Re: AUTOVACUUM after purging a lot of records

From: desmodemone
Date: 15 December 2013, 21:08:38
Subject: keep alive and running query