Search Postgresql Archives

Fwd: Request to share approach during REINDEX operation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux