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

Re: pg_start_backup() takes too long

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Ivan Zolotukhin <ivan(dot)zolotukhin(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_start_backup() takes too long
Date: 2008-09-23 02:18:52
Message-ID: 200809230218.m8N2Iqx25311@momjian.us (view raw or flat)
Thread:
Lists: pgsql-general
Ivan Zolotukhin wrote:
> Hello,
> 
> What is the reason for
> 
> select pg_start_backup('label');
> 
> taking 10 minutes on not so loaded system even right after manual checkpoint?

No idea;  something is seriously wrong if that is happening.  Do the
database server logs or kernel logs show anything unusual?

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-general by date

Next:From: Yi ZhaoDate: 2008-09-23 02:31:47
Subject: Re: how to return the first record from the sortedrecords which may have duplicated value.
Previous:From: Yi ZhaoDate: 2008-09-23 01:53:14
Subject: Re: how to return the first record from the sortedrecords which may have duplicated value.

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