Hi Steve,
Thanks for your reply.
My Postgresql version is 8.2. I amn't sure we have the autovacuum job running
or not? How can I check it ?
Thanks.
Grace
At 2012-05-18 02:53:15,Steve Crawford scrawf...@pinpointresearch.com wrote:
On 05/17/2012 11:30 AM, leaf_yxj wrote:
Hi Guys.
On 05/18/2012 06:47 AM, yxj wrote:
Hi Steve,
Thanks for your reply.
My Postgresql version is 8.2. I amn't sure we have the autovacuum job
running or not? How can I check it ?
Unless something is broken it is already running. You can connect to the
db and run show autovacuum;. It should be
Hi Guys. Please help me about this.
For postgres database, it looks like we need analyze and vacuum all the
tables periodly. I need to write a script which can be executed in crontab.
I don't have any clues about that. I only know the command :
analyze tablename;
vacuum tablename;
Please
On 05/17/2012 11:30 AM, leaf_yxj wrote:
Hi Guys. Please help me about this.
For postgres database, it looks like we need analyze and vacuum all the
tables periodly. I need to write a script which can be executed in crontab.
I don't have any clues about that. I only know the command :
analyze