Postgres Pro
Downloads
Home   >   mailing lists

Re: Canceling REINDEX safe? - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Canceling REINDEX safe?
Date
Msg-id CAGDYbUMs7tT=xxs1VprPk-SqmKOtsn-3gL=0Vv9uBwb=1NTt+g@mail.gmail.com
Whole thread Raw
In response to Re: Canceling REINDEX safe?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
Hi,
There will be some problem to the index as
REINDEX is a maintenance operation and generally done when index is corrupted, bloated etc.
REINDEX is a locking operation hence it is risky to perform on a busy table,
I suggest in case of index corruption instead of reindexing you can :
create an index concurrently and remove the old index in off peak hours.


Thanks & Regards,
Ajinkya Bangale
Database Administrator
ajinkya.bangale@shreeyansh.com
Office: +919552687400/8400

On Tue, Feb 17, 2015 at 8:43 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de> writes:
> I wonder whether canceling a REINDEX of a database is safe ( PostgreSQL v9.2.7 ).

Sure.  If it weren't cancel-safe, it wouldn't be crash-safe either.

                        regards, tom lane


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: Relocated Postgres
Next
From: "Rossi, Maria"
Date:
Subject: Re: Errorlog empty