Re: It is possible to force periodically switch xlog?

[Abdul Sayeed <abdulsayeed24@xxxxxxxxx>]

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@xxxxxxxxxxx> 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