Richard wrote:
pg_start_backup is rather slow, can I change checkpoint to CHECKPOINT_IMMEDIATE?
Starting in PostgreSQL 8.4, pg_start_backup takes an optional second parameter that asks it to do an immediate checkpoint if you set it true: http://www.postgresql.org/docs/8.4/interactive/functions-admin.html
In 8.3, it can be useful to execute a manual CHECKPOINT just before running pg_start_backup instead, so that the checkpoint it does will likely be smaller.
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
