Обсуждение: Why "vacuum_freeze_min_age" parameter has context as "USER" ?

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

Why "vacuum_freeze_min_age" parameter has context as "USER" ?

От
sudalai
Дата:
Hi,

     Can you please tell me what is the purpose of providing  * USER*
context to *vacuum_freeze_min_age* parameter.
I guess vacuum process only going to use it.  so if i changed
*vacuum_freeze_min_age* and issue VACCUM command on a session. Will postgres
VACCUM process takes the changes i made on the session? ...
Is any way to ensure that vacuum command takes  vacuum_freeze_min_age from
session...

Thanks in advance ...
Regards,
Sudalai.



-----
sudalai
--
View this message in context:
http://postgresql.nabble.com/Why-vacuum-freeze-min-age-parameter-has-context-as-USER-tp5831067.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.


Re: Why "vacuum_freeze_min_age" parameter has context as "USER" ?

От
Kevin Grittner
Дата:
sudalai <sudalait2@gmail.com> wrote:

> if i changed *vacuum_freeze_min_age* and issue VACCUM command on
> a session. Will postgres VACCUM process takes the changes i made
> on the session?

Yes, if you change it within a session and then run a VACUUM
command within that same session, the behavior of VACUUM will be
based on the session setting.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company