Skip site navigation (1) Skip section navigation (2)

Re: pg_start_backup() takes too long

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Ivan Zolotukhin <ivan(dot)zolotukhin(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_start_backup() takes too long
Date: 2008-09-28 16:18:05
Message-ID: 1222618685.4445.1040.camel@ebony.2ndQuadrant (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Sun, 2008-09-28 at 08:35 -0700, Joshua D. Drake wrote:
> Ivan Zolotukhin wrote:
> > Hello,
> > 
> > Nothing bad both in system and postgres logs :( No serious activity
> > during backup. I've had to change statement_timeout for backup user to
> > make it work. But I cannot reproduce this case unfortunately.
> This is actually not uncommon and PostgreSQL shows exactly nothing in 
> terms of why it is taking so long. The only assumption I have come up 
> with is that start_backup does cause a checkpoint.

Yes, it does a normal checkpoint and writes a file. No reason for it to
take longer than any other checkpoint.

At 8.2 and below checkpoints were frequently delayed on busy systems.
This was because of lwlock starvation during commit phase of
transactions. That was fixed in 8.3.

 Simon Riggs 
 PostgreSQL Training, Services and Support

In response to


pgsql-general by date

Next:From: Tom LaneDate: 2008-09-28 17:34:45
Subject: Re: Can anyone explain?
Previous:From: Joshua D. DrakeDate: 2008-09-28 15:35:49
Subject: Re: pg_start_backup() takes too long

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group