Run Vacuum Through JDBC

Поиск
Список
Период
Сортировка
От Yan Cheng CHEOK
Тема Run Vacuum Through JDBC
Дата
Msg-id 749824.82816.qm@web65709.mail.ac4.yahoo.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Archiver not picking up changes to archive_command
Следующее
От: venu madhav
Дата:
Сообщение: Performance issues when the number of records are around 10 Million