Attached is a patch that fixes overflow of bgwriter's file-fsync request queue.
It happened on heavy update workloads and the performance decreased. I have sent HACKERS the detail. --- ITAGAKI Takahiro NTT Cyber Space Laboratories
bgwriter-requests-queue-overflow-2.patch
Description: Binary data
---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match