Tom Lane <[EMAIL PROTECTED]> wrote: > > "ITAGAKI Takahiro" <[EMAIL PROTECTED]> wrote > >> AbsorbFsyncRequests will be called during the fsync loop in my patch, > >> so new files might be added to pendingOpsTable and they will be removed > >> from the table *before* writing the pages belonging to them. > > I think this fear is incorrect. At the time ForwardFsyncRequest is > called, the backend must *already* have done whatever write it is > concerned about fsync'ing.
Oops, I was wrong. Also, I see that there is no necessity for fearing endless loops because hash-seqscan and HASH_ENTER don't conflict. Attached is a revised patch. It became very simple, but I worry that one magic number (BUFFERS_PER_ABSORB) is still left. --- ITAGAKI Takahiro NTT Cyber Space Laboratories
bgwriter-requests-queue-overflow-3.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
