Re: Temporary tables prevent autovacuum, leading to XID wraparound

From:	Michael Paquier <michael(at)paquier(dot)xyz>
To:	Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc:	Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)lists(dot)postgresql(dot)org, "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, "tgl(at)sss(dot)pgh(dot)pa(dot)us" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "robertmhaas(at)gmail(dot)com" <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Temporary tables prevent autovacuum, leading to XID wraparound
Date:	2018-08-20 23:38:34
Message-ID:	20180820233834.GA2897@paquier.xyz
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2018-01-25 06:14:41 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>  2018-01-25 07:55:00 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>   2018-01-25 08:10:00 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>    2018-01-25 08:17:12 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>     2018-01-25 08:25:34 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>  2018-01-25 11:30:09 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>   2018-01-26 05:22:29 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>    2018-01-29 05:03:02 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>     2018-01-29 06:33:58 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>      2018-01-30 04:36:34 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>       2018-01-30 05:43:28 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>      2018-01-30 17:46:12 from Robert Haas <robertmhaas(at)gmail(dot)com>       2018-01-31 00:04:32 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>        2018-01-31 17:01:49 from Robert Haas <robertmhaas(at)gmail(dot)com>         2018-02-01 00:37:35 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>          2018-02-01 15:31:40 from Robert Haas <robertmhaas(at)gmail(dot)com>           2018-02-02 06:27:06 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>            2018-02-02 06:37:46 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>            2018-02-02 16:48:15 from Robert Haas <robertmhaas(at)gmail(dot)com>             2018-02-09 07:34:27 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>  2018-01-26 01:23:12 from Robert Haas <robertmhaas(at)gmail(dot)com>   2018-01-26 05:33:51 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>   2018-02-05 03:10:17 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎    2018-02-06 16:33:59 from Robert Haas <robertmhaas(at)gmail(dot)com>     2018-02-06 23:03:26 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>      2018-02-07 00:37:50 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>       2018-02-07 00:43:40 from Michael Paquier <michael(dot)paquier(at)gmail(dot)com>        2018-02-07 00:51:55 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>      2018-02-07 16:22:42 from Robert Haas <robertmhaas(at)gmail(dot)com>     2018-03-06 23:39:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2018-03-07 08:23:50 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>      2018-03-08 17:29:21 from Robert Haas <robertmhaas(at)gmail(dot)com>       2018-03-08 18:09:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2018-03-08 19:15:08 from Robert Haas <robertmhaas(at)gmail(dot)com>      2018-03-13 08:08:48 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎       2018-07-13 04:29:57 from Michael Paquier <michael(at)paquier(dot)xyz>        2018-07-18 07:34:10 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>         2018-07-26 10:05:11 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>          2018-07-27 06:28:40 from Michael Paquier <michael(at)paquier(dot)xyz> 📎           2018-07-27 08:27:26 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>            2018-07-30 07:59:16 from Michael Paquier <michael(at)paquier(dot)xyz> 📎             2018-07-31 04:39:07 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>              2018-08-08 08:33:06 from Michael Paquier <michael(at)paquier(dot)xyz>               2018-08-08 14:40:02 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                2018-08-08 14:50:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2018-08-08 16:42:29 from Michael Paquier <michael(at)paquier(dot)xyz>             2018-08-08 08:41:27 from Andres Freund <andres(at)anarazel(dot)de>              2018-08-08 19:11:17 from Michael Paquier <michael(at)paquier(dot)xyz>               2018-08-09 03:02:32 from Andres Freund <andres(at)anarazel(dot)de>                2018-08-09 07:00:29 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                 2018-08-09 09:29:54 from Andres Freund <andres(at)anarazel(dot)de>                  2018-08-09 16:50:47 from Michael Paquier <michael(at)paquier(dot)xyz>                   2018-08-13 09:54:14 from Michael Paquier <michael(at)paquier(dot)xyz>                   2018-08-13 09:56:16 from Andres Freund <andres(at)anarazel(dot)de>                    2018-08-13 17:03:59 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                     2018-08-13 17:15:07 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                      2018-08-14 16:23:57 from Michael Paquier <michael(at)paquier(dot)xyz>                 2018-08-13 16:53:18 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                  2018-08-14 16:53:32 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                   2018-08-19 23:09:52 from Michael Paquier <michael(at)paquier(dot)xyz>                    2018-08-20 13:54:28 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                     2018-08-20 23:38:34 from Michael Paquier <michael(at)paquier(dot)xyz>
Lists:	pgsql-hackers

In response to

• Re: Temporary tables prevent autovacuum, leading to XID wraparound at 2018-08-20 13:54:28 from Alvaro Herrera

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Kyotaro HORIGUCHI	2018-08-21 00:26:54	Re: Reopen logfile on SIGHUP
Previous Message	Bossart, Nathan	2018-08-20 20:57:00	Re: Improve behavior of concurrent ANALYZE/VACUUM