Re: pg_start_backup() takes too long

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: pg_start_backup() takes too long
Дата
Msg-id
200809230218.m8N2Iqx25311@momjian.us
Ответ на
pg_start_backup() takes too long (Ivan Zolotukhin)
Список
Дерево обсуждения
pg_start_backup() takes too long "Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>
Re: pg_start_backup() takes too long Bruce Momjian <bruce@momjian.us>
Re: pg_start_backup() takes too long "Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>
Re: pg_start_backup() takes too long "Joshua D. Drake" <jd@commandprompt.com>
Re: pg_start_backup() takes too long Simon Riggs <simon@2ndQuadrant.com>
Re: pg_start_backup() takes too long "Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>
Re: pg_start_backup() takes too long Simon Riggs <simon@2ndQuadrant.com>
Re: pg_start_backup() takes too long Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_start_backup() takes too long Simon Riggs <simon@2ndQuadrant.com>
Re: pg_start_backup() takes too long Bruce Momjian <bruce@momjian.us>
Re: pg_start_backup() takes too long Joshua Drake <jd@commandprompt.com>
Re: pg_start_backup() takes too long "Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>
Re: pg_start_backup() takes too long Simon Riggs <simon@2ndQuadrant.com>
Re: pg_start_backup() takes too long Greg Smith <gsmith@gregsmith.com> 
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          http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
В списке pgsql-general по дате отправления
Предыдущее
От: Yi Zhao
Дата:
Следующее
От: Yi Zhao
Дата:
FAQ