{"push_id":2695181251,"size":1,"distinct_size":1,"ref":"refs/heads/REL_11_STABLE","head":"9e53171b1057ddb50063a58651aff45f8fc339d7","before":"5fca035903a2ad2fd143b14eccf5a58af85c189d","commits":[{"sha":"9e53171b1057ddb50063a58651aff45f8fc339d7","author":{"name":"Fujii Masao","email":"1f6acd02e97f7332f0e624e7be5170a1e771cb87@postgresql.org"},"message":"Improve the performance of relation deletes during recovery.\n\nWhen multiple relations are deleted at the same transaction,\nthe files of those relations are deleted by one call to smgrdounlinkall(),\nwhich leads to scan whole shared_buffers only one time. OTOH,\npreviously, during recovery, smgrdounlink() (not smgrdounlinkall()) was\ncalled for each file to delete, which led to scan shared_buffers\nmultiple times. Obviously this could cause to increase the WAL replay\ntime very much especially when shared_buffers was huge.\n\nTo alleviate this situation, this commit changes the recovery so that\nit also calls smgrdounlinkall() only one time to delete multiple\nrelation files.\n\nThis is just fix for oversight of commit 279628a0a7, not new feature.\nSo, per discussion on pgsql-hackers, we concluded to backpatch this\nto all supported versions.\n\nAuthor: Fujii Masao\nReviewed-by: Michael Paquier, Andres Freund, Thomas Munro, Kyotaro Horiguchi, Takayuki Tsunakawa\nDiscussion: https://postgr.es/m/CAHGQGwHVQkdfDqtvGVkty+19cQakAydXn1etGND3X0PHbZ3+6w@mail.gmail.com","distinct":true,"url":"https://api.github.com/repos/postgres/postgres/commits/9e53171b1057ddb50063a58651aff45f8fc339d7"}]}
{"actor":{"display_login":"postgres-mirror"}}