Hot Standby btree delete records and vacuum_defer_cleanup_age
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndQuadrant.com>
To: pgsql-hackers@postgresql.org
Date: 2010-12-08T15:00:51Z
Lists: pgsql-hackers
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Reduce spurious Hot Standby conflicts from never-visible records.
- b9075a6d2f9b 9.1.0 cited
Attachments
- btree_vac_cleanup_age.v1.patch (text/x-patch) patch v1
Heikki pointed out to me that the btree delete record processing does not respect vacuum_defer_cleanup_age. It should. Attached patch to implement that. Looking to commit in next few hours barring objections/suggestions, to both HEAD and 9_0_STABLE, in time for next minor release. -- Simon Riggs http://www.2ndQuadrant.com/books/ PostgreSQL Development, 24x7 Support, Training and Services