[GENERAL] - Mailing list pgsql-general

From Yogesh Sharma
Subject [GENERAL]
Date
Msg-id CAEZUwCTmqjrvVnfh3j5wVMdfZwnEGHUe8Vdw+VVek2JYQAVx-g@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL]
List 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

pgsql-general by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [GENERAL] How well does PostgreSQL 9.6.1 support unicode?
Next
From: Yogesh Sharma
Date:
Subject: [GENERAL] Fwd: Request to share approach during REINDEX operation