>>>In my production system, there are lot of read write operation performed every hour.
>>Apologies if this sounds patronising but I just wanted to check - you know that indexes are updated automatically when write operations occur, right?
>Yes. You are correct.
OK - I think the folks here are having a hard time figuring out why you are reindexing so frequently, especially during times when the database is already under load.
What benefit does reindexing give you? Have you tried not doing it? The same goes for vacuuming - have you tried just letting autovacuum do its job, or tweaking its parameters to meet your needs?
(Also, list etiquette here seems to be to reply after the previous post, rather than “top-post”)
Steve.
This email is confidential. If you are not the intended recipient, please advise us immediately and delete this message. The registered name of Cantab- part of GAM Systematic is Cantab Capital Partners LLP. See - http://www.gam.com/en/Legal/Email+disclosures+EU for further information on confidentiality, the risks of non-secure electronic communication, and certain disclosures which we are required to make in accordance with applicable legislation and regulations. If you cannot access this link, please notify us by reply message and we will send the contents to you.
