Re: It is possible to force periodically switch xlog?

From: Abdul Sayeed <abdulsayeed24(at)gmail(dot)com>
To: Edson Richter <edsonrichter(at)hotmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: It is possible to force periodically switch xlog?
Date: 2020-04-01 22:11:06
Message-ID: CAHb=FFwpUZ3rSb+zMNqVUkOHfNd_YOOKWeCMHz-KL4oi5+tSqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hotmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2020-04-01 22:55:05 Re: It is possible to force periodically switch xlog?
Previous Message Edson Richter 2020-04-01 22:06:36 It is possible to force periodically switch xlog?