I would consider that DDL and the application should avoid doing it; otherwise, you end up with blocking issues where both readers and writers are blocked unnecessarily. The application issuing analyze on its own temp tables is fine and non blocking. If you must analyze tables then I would limit which processes have access to those tables to avoid blocking issues. I would look at your auto vacuum/analyze settings as oppose to the application issuing analyze commands as those are going to be a non blocking option. |
