From: | anand086 <anand086(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Analyze Table |
Date: | 2017-08-18 16:50:47 |
Message-ID: | 1503075047520-5979024.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello All,
We have a requirement wherein, analyze table needs to be called from within
the application.
To give a background, we have schema called "dev" under which all the tables
are created, then we have "dev_dba" user which has been granted ownership of
all tables and then we have "dev_user" (application user) accessing the data
from the java application.
The application code run as dev_user, needs to analyze the table in case
application does truncate and insert data (~ 10 millions rows).
As per my understanding, only the owner of the table can analyze the table
and we do not want to make "dev_user" the owner.
What is the best possible way to get the table analyzed from application
code without changing granting owner to dev_user?
Thank you for your time.
Regards,
Anand
--
View this message in context: http://www.postgresql-archive.org/Analyze-Table-tp5979024.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-08-18 16:59:32 | Re: Analyze Table |
Previous Message | Marco DE BOOIJ | 2017-08-18 12:11:12 | Problems when upgrading postgresql-contrib-9.6 |