Why create CHECKPOINT_WAIT checkpoint in pg_start_backup not CHECKPOINT_IMMEDIATE?

From: "Richard" <husttripper(at)vip(dot)sina(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Why create CHECKPOINT_WAIT checkpoint in pg_start_backup not CHECKPOINT_IMMEDIATE?
Date: 2010-08-05 14:27:42
Message-ID: 201008052227423092924@vip.sina.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-08-05 14:55:10 Re: could you tell me this..?
Previous Message Tom Lane 2010-08-05 14:10:44 Re: how can we resolving locking state....