Hi Ameya, Yes, you can just go to psql and invoke VACUUM FULL. But before you do, you may want to check the manifoldcf.log file for log entries describing slow-running queries. It's not unusual to see some of these from normal use, but if you start to see queries from the "stuffer thread" which are slow-running, you may be running into known query optimization issues that PostgreSQL exhibits. There's a different workaround for that problem than VACUUM FULL, so it is good to know what the situation actually is.
Thanks, Karl On Mon, Jul 28, 2014 at 11:02 AM, Ameya Aware <[email protected]> wrote: > Hi, > > I am seeing considerable decrease in speed of indexing of documents. > > I am using PostgreSQL. > > So is this a right time to do vacuum on PostgreSQL because i am using this > since a week. > > > Also, to invoke vacuum full do i just need to go to PostgreSQL command > prompt and invoke "VACUUM FULL" command? > > > Thanks, > Ameya >
