Re: Improving index maintenance suggestions

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Greg Smith <greg(at)2ndQuadrant(dot)com>
Cc: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Improving index maintenance suggestions
Date: 2014-01-30 17:16:07
Message-ID: 20140130171607.GA20260@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Wed, Jul 17, 2013 at 10:08:44PM -0400, Greg Smith wrote:
> The attached documentation patch overhauls the "Routine Reindexing"
> documentation to introduce production index rebuilding techniques.
> REBUILD is useless for a lot of environments, replaced with CREATE
> INDEX CONCURRENTLY and various naming shuffles if you want the new
> index to have the same name. I tried to link to all of the commands
> needed to pull that off usefully.

Adjusted patch applied, and backpatched to 9.3. We don't normally patch
non-fix patches earlier than the most recent stable release. Thanks.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2014-01-31 17:28:15 Re: make vs. gmake
Previous Message Vik Fearing 2014-01-29 14:20:11 Re: Links for upgraders