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

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,

Browse pgsql-bugs by date

  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