Run Vacuum Through JDBC

On 11/05/10 13:38, Yan Cheng CHEOK wrote:

I was wondering, how can I check whether Vacuum operation had been executed without problem?

I use the following Java code to execute Vacuum operation

final Statement st2 = connection.createStatement();
st2.executeUpdate("VACUUM FULL ANALYZE VERBOSE");
st2.close();

Nothing print out at console.

I check at server status through pgadmin, also get no hint whether Vacuum operation had been executed.

That looks like Java / JDBC code.

If so - if executing the statement doesn't throw SQLException, then it
worked. Same as all other SQL.

--
Craig Ringer

Tech-related writing: http://soapyfrogs.blogspot.com/

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

On Mon, May 10, 2010 at 11:38 PM, Yan Cheng CHEOK <yccheok@yahoo.com> wrote:

I was wondering, how can I check whether Vacuum operation had been executed without problem?

I use the following Java code to execute Vacuum operation

final Statement st2 = connection.createStatement();
st2.executeUpdate("VACUUM FULL ANALYZE VERBOSE");
st2.close();

On a side note, unless you have extenuating circumstances, vacuum is
preferred over vacuum full. If you must run vacuum full, pay
attention to possible index bloating.