pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Canceling REINDEX safe?
3+ messages / 3 participants
[nested] [flat]

* Canceling REINDEX safe?
@ 2015-02-17 13:52  Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  0 siblings, 1 reply; 3+ messages in thread

From: Jan-Peter Seifert @ 2015-02-17 13:52 UTC (permalink / raw)
  To: pgsql-admin

Hello,

I wonder whether canceling a REINDEX of a database is safe ( PostgreSQL v9.2.7 ). In the server log there's just the error message that the REINDEX statement has been canceled without details.
Is the index that has been worked on when canceling okay or can it be incomplete or even get lost?

I don't see anything regarding this:
http://www.postgresql.org/docs/9.2/static/sql-reindex.html

Thank you very much in advance!

Best regards,

Peter


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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Canceling REINDEX safe?
@ 2015-02-17 15:13  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2015-02-17 15:13 UTC (permalink / raw)
  To: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>; +Cc: pgsql-admin

"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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Canceling REINDEX safe?
@ 2015-03-12 11:53  Shreeyansh Dba <shreeyansh2014@gmail.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Shreeyansh Dba @ 2015-03-12 11:53 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>; pgsql-admin

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
www.shreeyansh.com

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
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2015-03-12 11:53 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-02-17 13:52 Canceling REINDEX safe? Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2015-02-17 15:13 ` Tom Lane <tgl@sss.pgh.pa.us>
2015-03-12 11:53   ` Shreeyansh Dba <shreeyansh2014@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox