Re: checkpoint occurs very often when vacuum full running

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

To: Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx>, "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>, "pgsql-performance@xxxxxxxxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
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: Re: Can't find a relation in pg_class
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

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux