Re: script to drop and build all indexes in database

From: bricklen <bricklen(at)gmail(dot)com>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: script to drop and build all indexes in database
Date: 2013-12-13 23:05:20
Message-ID: CAGrpgQ_yN3FDPFNXfB1sicj2TLwWvNxyFGTvDNV35R1FiYcOvg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Dec 13, 2013 at 1:55 PM, Campbell, Lance <lance(at)illinois(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message desmodemone 2013-12-15 18:08:32 keep alive and running query
Previous Message Kevin Grittner 2013-12-13 22:31:44 Re: AUTOVACUUM after purging a lot of records