Postgres Pro
Downloads
Home   >   mailing lists

Re: It is possible to force periodically switch xlog? - Mailing list pgsql-general

From Abdul Sayeed
Subject Re: It is possible to force periodically switch xlog?
Date
Msg-id CAHb=FFwpUZ3rSb+zMNqVUkOHfNd_YOOKWeCMHz-KL4oi5+tSqA@mail.gmail.com
Whole thread Raw
In response to It is possible to force periodically switch xlog?  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: It is possible to force periodically switch xlog?
List pgsql-general
Tree view
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 by date:

Previous
From: Edson Richter
Date:
Subject: It is possible to force periodically switch xlog?
Next
From: Alvaro Herrera
Date:
Subject: Re: It is possible to force periodically switch xlog?