Re: pg_basebackup blocking all queries with horrible performance

Поиск
Список
Период
Сортировка
От Lonni J Friedman
Тема Re: pg_basebackup blocking all queries with horrible performance
Дата
Msg-id CAP=oouEu0sRCTvk+99wr-k3HG1vN3pyL4PXvVPQ+UZcAz6x2_g@mail.gmail.com
обсуждение исходный текст
Ответ на pg_basebackup blocking all queries with horrible performance  (Lonni J Friedman <netllama@gmail.com>)
Ответы Re: pg_basebackup blocking all queries with horrible performance
Список pgsql-admin
Дерево обсуждения 
On Thu, Jun 7, 2012 at 10:41 AM, Lonni J Friedman <netllama@gmail.com> wrote:
> Greetings,
> I have a 4 server postgresql-9.1.3 cluster (one master doing streaming
> replication to 3 hot standby servers).  All of them are running
> Fedora-16-x86_64.
>
> http://wiki.postgresql.org/wiki/Lock_Monitoring

err, i included that URL but neglected to explain why.  On a different
list someone suggested that I verify that there were no locks that
were blocking things, and I did so, and found no locks.

So I'm still at a loss why pg_basebackup is killing perf, and would
appreciate pointers on how to debug it or at least reduce its impact
on performance if that is possible.

tahnks

В списке pgsql-admin по дате отправления:

Предыдущее
От: Fabricio
Дата:
Сообщение: could not rename temporary statistics file "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": No such file or directory
Следующее
От: Amador Alvarez
Дата:
Сообщение: Re: Can schemas be ordered regarding their creation time ?