Run Vacuum Through JDBC

From: Yan Cheng CHEOK <yccheok(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Run Vacuum Through JDBC
Date: 2010-05-11 05:38:15
Message-ID: 749824.82816.qm@web65709.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message venu madhav 2010-05-11 06:18:22 Performance issues when the number of records are around 10 Million
Previous Message Fujii Masao 2010-05-11 04:21:16 Re: Archiver not picking up changes to archive_command