Re: BUG #13515: Much higher disk writes after postgres upgrade 9.4.3->9.4.

Поиск
Список
Период
Сортировка
От Sushant Sinha
Тема Re: BUG #13515: Much higher disk writes after postgres upgrade 9.4.3->9.4.
Дата
Msg-id CAK=sinVk_XyE30rF57ML7+GyFT_AR2Ajj2a99a-HE6L2C6THoQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-bugs
I have reported this bug earlier of much higher disk writes after upgrading
from Postgres 9.4.3 to 9.4.4. I wanted to check if I should produce any
other details for fixing the issue.

After upgrade from postgres 9.4.3 to 9.4.4 I was seeing constant disk writes
  of 4-8MB/s in the background in production. I verified it using iotop and
 vmstat. iotop shows "Total Disk Write" to be minuscule (like 10-100Kbps)
but high
"Actual disk writes". It  is affecting runtime performance. Postgres
 9.4.3 does not have this issue.

It was a continuous disk write even when there was no autovacuum process
running.
It was happening even on a database in which there were no
inserts/deletes/modify
and did vacuum manually.

-Sushant,

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #13559: WAL replay stuck after DROP VIEW
Следующее
От: Haribabu Kommi
Дата:
Сообщение: Re: BUG #13541: There is a visibility issue when run some DDL and Query. The time window is very shot