Home > mailing lists

Why create CHECKPOINT_WAIT checkpoint in pg_start_backup not CHECKPOINT_IMMEDIATE? - Mailing list pgsql-general

From	Richard
Subject	Why create CHECKPOINT_WAIT checkpoint in pg_start_backup not CHECKPOINT_IMMEDIATE?
Date	August 5, 2010 14:27:53
Msg-id	201008052227423092924@vip.sina.com Whole thread Raw
Responses	Re: Why create CHECKPOINT_WAIT checkpoint in pg_start_backup not CHECKPOINT_IMMEDIATE?
List	pgsql-general

pg_start_backup is rather slow, can I change checkpoint to  CHECKPOINT_IMMEDIATE?

--------------
Richard
2010-08-05

From: Tom Lane
Date: 05 August 2010, 14:10:58
Subject: Re: how can we resolving locking state....

From: Vick Khera
Date: 05 August 2010, 14:55:20
Subject: Re: could you tell me this..?