Re: It is possible to force periodically switch xlog?

Поиск
Список
Период
Сортировка
От Abdul Sayeed
Тема Re: It is possible to force periodically switch xlog?
Дата
Msg-id CAHb=FFwpUZ3rSb+zMNqVUkOHfNd_YOOKWeCMHz-KL4oi5+tSqA@mail.gmail.com
обсуждение исходный текст
Ответ на It is possible to force periodically switch xlog?  (Edson Richter <edsonrichter@hotmail.com>)
Ответы Re: It is possible to force periodically switch xlog?
Список pgsql-general
Hi Edson,

You can switch by using below command below PG 10.

Select pg_switch_xlog();

And there is no parameter present to switch it.



Regards,
Abdul Sayeed

On Thursday, April 2, 2020, Edson Richter <edsonrichter@hotmail.com> wrote:
I would like to know if there is any parameter I can set to force postgres to switch xlog periodically, even if it not reach the 16MB size?

Thanks,

Edson.



--
Thanks & Regards,
Abdul Sayeed
PostgreSQL DBA 
Postgres Professional Certified
Skype: abdul.sayeed24

В списке pgsql-general по дате отправления:

Предыдущее
От: Edson Richter
Дата:
Сообщение: It is possible to force periodically switch xlog?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: It is possible to force periodically switch xlog?