autovacuum daemon

On 21/01/2009 07:47, Abdul Rahman wrote:

I have set postgresql.conf for autovacuum and need to know weather
the process is running/working or not.

ps ax | grep postgres

Ray.

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

On 21/01/2009 14:57, Raymond O'Donnell wrote:

On 21/01/2009 07:47, Abdul Rahman wrote:

I have set postgresql.conf for autovacuum and need to know weather
the process is running/working or not.

ps ax | grep postgres

Also, in psql:

postgres=# show autovacuum;
autovacuum
------------
on
(1 row)

HTH,

Ray.

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

select * from pg_autovacuum;

--
GJ

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Abdul Rahman schrieb:

Deal All,

I have set postgresql.conf for autovacuum and need to know weather the
process is running/working or not.

Hi Abdul,

1. you could check the log file

2. select setting from pg_settings where name = 'autovacuum';

Cheers

Andy

- -- Andreas Wenk St.Pauli - Hamburg - Germany

Regards,
Avdul Rehman.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJdzk6Va7znmSP9AwRAk2nAJ9eeGtXGZbyMoPFZwukmg0T/4sWtgCg28iN
B6m0nEgLALvIv2ZGZt9syvs=
=4zR5
-----END PGP SIGNATURE-----

[ Grzegorz, please include some context ]

On Wed, Jan 21, 2009 at 03:01:39PM +0000, Grzegorz Jaaakiewicz wrote:

Avdul Rehman wrote:

I have set postgresql.conf for autovacuum and need to know weather
the process is running/working or not.

select * from pg_autovacuum;

This won't do what the OP was asking for; pg_autovacuum only records
non-default autovacuum parameters where they have been set by the
user/admin. More details here:

http://www.postgresql.org/docs/current/static/catalog-pg-autovacuum.html

--
Sam http://samason.me.uk/

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.

Thanks Ray,

Your solution of using ps command is for Linux but I am using WinXp. That is why it confused me.

Regards,
Abdul Rehman.

On 22/01/2009 07:15, Abdul Rahman wrote:

Your solution of using ps command is for Linux but I am using WinXp.
That is why it confused me.

No problem! :-) It occurred to me after I sent the email that you might
not be on Linux....

It's a good idea, when posting questions, to include as much background
detail as you can - platform, PG version, etc etc - it helps you get an
answer to your specific problem more quickly, as it saves back-and-forth
questions about this stuff.

Ray.

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

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@iol.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