Skip site navigation (1) Skip section navigation (2)

Re: Support for REINDEX CONCURRENTLY

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Subject: Re: Support for REINDEX CONCURRENTLY
Date: 2012-10-03 08:33:31
Message-ID: CA+U5nMKUZ9+2f=b+yxzi6AmUxgN8BYH6XKPQBRRJPA=4RL7k4A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers 
On 3 October 2012 09:10, Andres Freund <andres(at)2ndquadrant(dot)com> wrote:

>> The following restrictions are applied.
>> - REINDEX [ DATABASE | SYSTEM ] cannot be run concurrently.

> I would like to support something like REINDEX USER TABLES; or similar at some
> point, but that very well can be a second phase.

Yes, that would be a nice feature anyway, even without concurrently.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

pgsql-hackers by date

Next:From: Boszormenyi ZoltanDate: 2012-10-03 08:37:27
Subject: Re: [PATCH] Make pg_basebackup configure and start standby
Previous:From: Michael PaquierDate: 2012-10-03 08:27:46
Subject: Re: Support for REINDEX CONCURRENTLY

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group