Run Vacuum Through JDBC - Mailing list pgsql-general

From Yan Cheng CHEOK
Subject Run Vacuum Through JDBC
Date
Msg-id 749824.82816.qm@web65709.mail.ac4.yahoo.com
Whole thread Raw
Responses Re: Run Vacuum Through JDBC  (Craig Ringer <craig@postnewspapers.com.au>)
Re: Run Vacuum Through JDBC  (Kris Jurka <books@ejurka.com>)
Re: Run Vacuum Through JDBC  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
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





pgsql-general by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Archiver not picking up changes to archive_command
Next
From: venu madhav
Date:
Subject: Performance issues when the number of records are around 10 Million