Postgres Pro
Downloads
Home   >   mailing lists

Re: checkpoint occurs very often when vacuum full running - Mailing list pgsql-admin

From Sergei Kornilov
Subject Re: checkpoint occurs very often when vacuum full running
Date
Msg-id 6028761542309042@myt3-c573aa6fc782.qloud-c.yandex.net
Whole thread Raw
In response to checkpoint occurs very often when vacuum full running  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: checkpoint occurs very often when vacuum full running  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Re: checkpoint occurs very often when vacuum full running  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can't find a relation in pg_class
Next
From: Mariel Cherkassky
Date:
Subject: Re: checkpoint occurs very often when vacuum full running