Re: Run Vacuum Through JDBC

From: Kris Jurka <books(at)ejurka(dot)com>
To: Yan Cheng CHEOK <yccheok(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Run Vacuum Through JDBC
Date: 2010-05-11 18:58:17
Message-ID: alpine.BSO.2.00.1005111457130.11093@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2010-05-11 19:08:32 Re: PostgreSQL 9.0 beta1 and pg_upgrade
Previous Message Glen Barber 2010-05-11 18:31:17 PostgreSQL 9.0 beta1 and pg_upgrade