Re: autovacuum daemon

From: Abdul Rahman <abr_ora(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: autovacuum daemon
Date: 2009-01-22 06:06:00
Message-ID: 817318.94992.qm@web65709.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear All,

Thanks for fruitful replies. But I checked it by running ANALYZE on psql. First updated 10000 rows in a table and got certain number of dead rows in result of ANALYZE. After few minutes the number of dead rows becomes zero which assured me that AUTOVACUUM is running in background.

Now, kindly let me know the detail about the solution send by Ray, i.e.

ps ax | grep postgres

Regards,
Abdul Rehman.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abdul Rahman 2009-01-22 07:15:07 Re: autovacuum daemon
Previous Message Rodrigo E. De León Plicet 2009-01-22 05:11:48 Re: Check if column is substring of another column