I'm newbie in postgres and have a question:
we have some clients that have ultra-super-secure-sensitive data on postgres and they don't want to show it anyone. but sometime, the apps experience some degradation because of not quite fresh statistics or another reasons.
Question: How to maintain performance without actual business data access? i mean particular functionality:
- how to run 'analyze',
- 'explain analyze' on another user's table
- query without superuser privileges.
I believe a restricted maintenance user may help here (I guess the only thing that may do this maintenance user is to do 'analyze' and 'explain analyze') but still have lake of knowledge how to achieve it.
May be you have another great ideas in your mind?