Re: Blocked updates and background writer performance

Anyway, it looks to me like you have a checkpoint problem.  The checkpoint overwhelms your IO system.  The overwhelmed IO system then backs up into the bgwriter.  What you see in the bgwriter is just a symptom, not the cause.  The background writer is usually not very useful in recent versions of PostgreSQL, anyway.  But, the same IO problem that is clogging up the background writer is also clogging up either your buffer_backend, or your WAL writes/fsyncs.  And both of those will destroy your throughput.