We are reindexing frequently, and I'm wondering if
this is really necessary, given that it appears to
take an exclusive lock on the table.
Our table in question is vacuumed every 4 minutes, and
we are reindexing after each one.
I'm not a fan of locking this table that frequently,
even if it is only for 5 - 10 seconds depending on
load.
The vacuum is a standard vacuum. Nightly we do a
vacuum analyze.
Thanks for any tips,
...Markus