Re: autovacuum daemon

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.

Abdul Rahman wrote on 22.01.2009 07:06:
> Now, kindly let me know the detail about the solution send by Ray, i.e.
>
> ps ax | grep postgres

For WindowsXP the above command can be written as:

tasklist /v /fi "imagename eq postgres.exe"

Thomas

On 25/01/2009 13:37, Thomas Kellerer wrote:
> Abdul Rahman wrote on 22.01.2009 07:06:
>> Now, kindly let me know the detail about the solution send by Ray, i.e.
>>
>> ps ax | grep postgres
>
> For WindowsXP the above command can be written as:
>
> tasklist /v /fi "imagename eq postgres.exe"

Cool! I didn't know that one. Must R some more FMs.... :-)

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Raymond O'Donnell wrote on 25.01.2009 19:28:
>> For WindowsXP the above command can be written as:
>>
>> tasklist /v /fi "imagename eq postgres.exe"
>
> Cool! I didn't know that one. Must R some more FMs.... :-)

No need for manuals :)

Just enter "takslist /?"

Regards
Thomas