Обсуждение: autovacuum daemon

Поиск
Список
Период
Сортировка

autovacuum daemon

От
Abdul Rahman
Дата:
Deal All,

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

Regards,
Avdul Rehman.

Re: autovacuum daemon

От
Alvaro Herrera
Дата:
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.

Re: autovacuum daemon

От
Andreas Wenk
Дата:
-----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-----