Date: Fri, 18 Aug 2017 09:50:47 -0700 (MST)
From: anand086 <anand086@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1503075047520-5979024.post@n3.nabble.com>
Subject: Analyze Table
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin