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

Поиск
Список
Период
Сортировка
От Yogesh Sharma
Тема [GENERAL] Fwd: Request to share approach during REINDEX operation
Дата
Msg-id CAEZUwCTD5Dc2uv7b-VtiagAX78n3ho-Z7_0r6J9wGeEhfemMYw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Fwd: Request to share approach during REINDEX operation
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Yogesh Sharma
Дата:
Сообщение: [GENERAL]
Следующее
От: Tom DalPozzo
Дата:
Сообщение: [GENERAL] error updating a tuple after promoting a standby