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.