Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W8vDr-0004LW-Jy for pgsql-docs@arkaria.postgresql.org; Thu, 30 Jan 2014 17:16:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W8vDr-0007vo-4H for pgsql-docs@arkaria.postgresql.org; Thu, 30 Jan 2014 17:16:15 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W8vDq-0007vi-HW for pgsql-docs@postgresql.org; Thu, 30 Jan 2014 17:16:14 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W8vDk-0001Jt-E8 for pgsql-docs@postgresql.org; Thu, 30 Jan 2014 17:16:13 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1W8vDj-0002vu-J0; Thu, 30 Jan 2014 12:16:07 -0500 Date: Thu, 30 Jan 2014 12:16:07 -0500 From: Bruce Momjian To: Greg Smith Cc: pgsql-docs Subject: Re: Improving index maintenance suggestions Message-ID: <20140130171607.GA20260@momjian.us> References: <51E74E2C.8020505@2ndQuadrant.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <51E74E2C.8020505@2ndQuadrant.com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -2.3 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org 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 http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs