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.
Advertising
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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
