Re: [GENERAL] Fwd: Request to share approach during REINDEX operation

2016-12-21 Thread Vick Khera 
On Wed, Dec 21, 2016 at 4:02 AM, Yogesh Sharma  wrote:
> Also, every hour,i am performing VACUUM and REINDEX operation on table.

Why?


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

[GENERAL] Fwd: Request to share approach during REINDEX operation

2016-12-21 Thread Yogesh Sharma 
Adding subject line


Dear All,

Thanks for your support.
I am using postgresql 9.3.6 on RHEL6.6 machine.
In my production environment, Some script are executing automatically
through cron.
These script are performing insert and update operation.

Also, every hour,i am performing VACUUM and REINDEX operation on table.

Is there any solution available to perform only REINDEX operation and other
insert or updation operations from other script will not perform during
REINDEX execution?
  OR
Preferably, during REINDEX operation, other script execution for
insert/update may wait until reindex will not completed.

Regards,
Yogesh