On Mon, 10 May 2010, Yan Cheng CHEOK wrote:
I was wondering, how can I check whether Vacuum operation had been
executed without problem?
final Statement st2 = connection.createStatement();
st2.executeUpdate("VACUUM FULL ANALYZE VERBOSE");
st2.close();
Nothing print out at console.
The results of the vacuum are available in Statement.getWarnings().
Kris Jurka
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general