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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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