Reset temp schema on connection to prevent XID wraparound

ID 1505

Title Reset temp schema on connection to prevent XID wraparound

Topic Bug Fixes

Created 2018-02-05 03:25:45

Last modified 2018-08-13 09:55:53 (6 years, 3 months ago)

Latest email 2018-08-20 23:38:34 (6 years, 3 months ago)

Status

2018-09: Committed

2018-07: Moved to next CF

2018-03: Moved to next CF

Target version

Authors Takayuki Tsunakawa (maumau)

Reviewers Michael Paquier (michael-kun)Become reviewer

Committer Michael Paquier (michael-kun)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/1505
git checkout commitfest/cf/1505

Emails

Temporary tables prevent autovacuum, leading to XID wraparound: First at 2018-01-25 06:14:41 by "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com>
Latest at 2018-08-20 23:38:34 by Michael Paquier <michael at paquier.xyz>
Latest attachment (temp-namespace-comments-2.patch) at 2018-08-14 16:53:32 from Michael Paquier <michael at paquier.xyz>
    Attachment (temp-namespace-comments-2.patch) at 2018-08-14 16:53:32 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (temp-namespace-comments.patch) at 2018-08-13 17:03:59 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Make-autovacuum-more-aggressive-to-remove-orphaned-t.patch) at 2018-08-09 07:00:29 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (0001-Make-autovacuum-more-aggressive-to-remove-orphaned-t.patch) at 2018-07-30 07:59:16 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (reset_temp_schema_v3.patch) at 2018-07-27 06:28:40 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (reset_temp_schema_v2.patch) at 2018-03-13 08:08:48 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)
    Attachment (reset_temp_schema_on_connect.patch) at 2018-02-05 03:10:17 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)

History

When	Who	What
2018-08-13 09:55:53	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Committed
2018-08-10 22:44:36	Andrew Dunstan (adunstan)	New status: Waiting on Author
2018-08-10 22:33:54	Andrew Dunstan (adunstan)	Closed in commitfest 2018-07 with status: Moved to next CF
2018-08-10 22:33:48	Andrew Dunstan (adunstan)	New status: Needs review
2018-07-27 06:30:16	Michael Paquier (michael-kun)	Changed committer to michael-kun
2018-07-13 04:53:10	Michael Paquier (michael-kun)	New status: Waiting on Author
2018-07-13 04:53:06	Michael Paquier (michael-kun)	Changed reviewers to Michael Paquier (michael-kun)
2018-04-10 18:19:20	David Steele (dsteele)	Closed in commitfest 2018-03 with status: Moved to next CF
2018-02-05 03:28:11	Takayuki Tsunakawa (maumau)	Changed authors to Takayuki Tsunakawa (maumau)
2018-02-05 03:25:45	Takayuki Tsunakawa (maumau)	Attached mail thread 0A3221C70F24FB45833433255569204D1F8A4DC6@G01JPEXMBYT05
2018-02-05 03:25:45	Takayuki Tsunakawa (maumau)	Created patch record