From: Yogesh Sharma <yogeshraj95(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject:
Date: 2016-12-21 08:59:49
Message-ID: CAEZUwCTmqjrvVnfh3j5wVMdfZwnEGHUe8Vdw+VVek2JYQAVx-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

  • Re: at 2016-12-21 11:34:09 from Alban Hertroys

Browse pgsql-general by date

  From Date Subject
Next Message Yogesh Sharma 2016-12-21 09:02:34 Fwd: Request to share approach during REINDEX operation
Previous Message Kyotaro HORIGUCHI 2016-12-21 07:56:37 Re: How well does PostgreSQL 9.6.1 support unicode?