Re: pg_start_backup() takes too long - Mailing list pgsql-general

From Bruce Momjian
Subject Re: pg_start_backup() takes too long
Date
Msg-id 200809230218.m8N2Iqx25311@momjian.us
Whole thread Raw
In response to pg_start_backup() takes too long  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
Responses Re: pg_start_backup() takes too long  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
List 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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

pgsql-general by date:

Previous
From: Yi Zhao
Date:
Subject: Re: how to return the first record from the sorted records which may have duplicated value.
Next
From: Yi Zhao
Date:
Subject: Re: how to return the first record from the sorted records which may have duplicated value.