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 or flat)
Thread:
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           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


In response to

Responses

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-2014 The PostgreSQL Global Development Group