Re: High CPU on read-only streaming replication server

Поиск
Список
Период
Сортировка
От Nick
Тема Re: High CPU on read-only streaming replication server
Дата
Msg-id 1ef6181b-0498-41c2-a98f-b1e8c0052d0c@re8g2000pbc.googlegroups.com
обсуждение исходный текст
Список pgsql-general
On Jul 19, 1:23 pm, Nick <nboutel...@gmail.com> wrote:
> My read-only streaming replication servers are showing a much higher
> CPU load than I would expect.
>
> None of my queries are longer than 10ms.
>
> My application server is connecting to this server via pgbouncer.
>
> Other than that, its a pretty standard setup. I haven't toyed with too
> many settings besides the standard optimization settings.
>
> Any ideas what could be going on?

One more thing to point out, the top process that shows high CPU is...
COMMAND: postgres: dbuser mydatabase X.XX.XXX.XXX(XXXX) idle
CPU%: 68%

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

Предыдущее
От: Mark Wynter
Дата:
Сообщение: Problem setting environmental variables for postgresql or plpythonu
Следующее
От: "Martin French"
Дата:
Сообщение: Re: How to stop a query