Re: checkpoint occurs very often when vacuum full running

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: checkpoint occurs very often when vacuum full running
From: Sergei Kornilov <sk@xxxxxxxx>
Date: Thu, 15 Nov 2018 22:10:42 +0300
In-reply-to: <CA+t6e1=-OJ8XEitrH9GVDoHXQKNTkYN27O4cKmq5vkiGWbp3zA@mail.gmail.com>
References: <CA+t6e1=-OJ8XEitrH9GVDoHXQKNTkYN27O4cKmq5vkiGWbp3zA@mail.gmail.com>

Hi

Checkpoint can be occurs due timeout (checkpoint_timeout) or due amount of WAL (max_wal_size).
Vacuum full does write all data through WAL and therefore may trigger checkpoint more frequently.

regards, Sergei

Follow-Ups:
- Re: checkpoint occurs very often when vacuum full running
  - From: Mariel Cherkassky

References:
- checkpoint occurs very often when vacuum full running
  - From: Mariel Cherkassky

Prev by Date: checkpoint occurs very often when vacuum full running
Next by Date: Re: checkpoint occurs very often when vacuum full running
Previous by thread: checkpoint occurs very often when vacuum full running
Next by thread: Re: checkpoint occurs very often when vacuum full running
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux