Обсуждение: Run Vacuum Through JDBC

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.

Thanks and Regards
Yan Cheng CHEOK

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.