pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedautovacuum daemon
3+ messages / 3 participants
[nested] [flat]
* autovacuum daemon
@ 2009-01-21 07:46 Abdul Rahman <abr_ora@yahoo.com>
2009-01-21 15:14 ` Re: autovacuum daemon Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 3+ messages in thread
From: Abdul Rahman @ 2009-01-21 07:46 UTC (permalink / raw)
To: pgsql-admin
Deal All,
I have set postgresql.conf for autovacuum and need to know weather the process is running/working or not.
Regards,
Avdul Rehman.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: autovacuum daemon
2009-01-21 07:46 autovacuum daemon Abdul Rahman <abr_ora@yahoo.com>
@ 2009-01-21 15:14 ` Alvaro Herrera <alvherre@commandprompt.com>
2009-01-21 15:34 ` Re: autovacuum daemon Andreas Wenk <a.wenk@netzmeister-st-pauli.de>
0 siblings, 1 reply; 3+ messages in thread
From: Alvaro Herrera @ 2009-01-21 15:14 UTC (permalink / raw)
To: Abdul Rahman <abr_ora@yahoo.com>; +Cc: pgsql-admin
Abdul Rahman wrote:
> Deal All,
>
> I have set postgresql.conf for autovacuum and need to know weather the
> process is running/working or not.
Run this query:
SHOW autovacuum;
If it says "on", then it is working.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: autovacuum daemon
2009-01-21 07:46 autovacuum daemon Abdul Rahman <abr_ora@yahoo.com>
2009-01-21 15:14 ` Re: autovacuum daemon Alvaro Herrera <alvherre@commandprompt.com>
@ 2009-01-21 15:34 ` Andreas Wenk <a.wenk@netzmeister-st-pauli.de>
0 siblings, 0 replies; 3+ messages in thread
From: Andreas Wenk @ 2009-01-21 15:34 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: Abdul Rahman <abr_ora@yahoo.com>; pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Alvaro Herrera schrieb:
> Abdul Rahman wrote:
>> Deal All,
>>
>> I have set postgresql.conf for autovacuum and need to know weather the
>> process is running/working or not.
>
> Run this query:
> SHOW autovacuum;
way easiere than my approach ;-)
Thanks!
Andy
- --
St.Pauli - Hamburg - Germany
Andreas Wenk
>
> If it says "on", then it is working.
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJd0CPVa7znmSP9AwRAq0bAKDUENJo040IJDoDfEUKHUFMd61jqACg0X02
NljMvjCXVvNObOwFXlpVGbA=
=ba05
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2009-01-21 15:34 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-01-21 07:46 autovacuum daemon Abdul Rahman <abr_ora@yahoo.com>
2009-01-21 15:14 ` Alvaro Herrera <alvherre@commandprompt.com>
2009-01-21 15:34 ` Andreas Wenk <a.wenk@netzmeister-st-pauli.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox