From: | Sushant Sinha <sushant(at)indiankanoon(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #13515: Much higher disk writes after postgres upgrade 9.4.3->9.4. |
Date: | 2015-08-11 04:30:16 |
Message-ID: | CAK=sinVk_XyE30rF57ML7+GyFT_AR2Ajj2a99a-HE6L2C6THoQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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,
From | Date | Subject | |
---|---|---|---|
Next Message | manuel.pallier | 2015-08-11 05:41:46 | BUG #13561: "could not write to log file, Bad file descriptor" error when working with huge table |
Previous Message | Michael Paquier | 2015-08-11 04:19:13 | Re: BUG #13559: WAL replay stuck after DROP VIEW |