Re: reloption to prevent VACUUM from truncating empty pages at the end of relation

From:	Andres Freund <andres(at)anarazel(dot)de>
To:	Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc:	Robert Haas <robertmhaas(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, David Steele <david(at)pgmasters(dot)net>, "Bossart, Nathan" <bossartn(at)amazon(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "Jamison, Kirk" <k(dot)jamison(at)jp(dot)fujitsu(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: reloption to prevent VACUUM from truncating empty pages at the end of relation
Date:	2019-04-08 01:08:22
Message-ID:	20190408010822.kh3gqodtismkv7ay@alap3.anarazel.de
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2018-04-17 17:35:47 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>  2018-04-17 18:09:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2018-04-17 18:13:57 from Peter Geoghegan <pg(at)bowt(dot)ie>   2018-04-17 18:18:36 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>    2018-04-17 19:09:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2018-04-17 19:12:26 from Andres Freund <andres(at)anarazel(dot)de>      2018-04-18 01:00:59 from Michael Paquier <michael(at)paquier(dot)xyz>       2018-04-18 01:13:31 from Andres Freund <andres(at)anarazel(dot)de>        2018-04-18 01:46:51 from Michael Paquier <michael(at)paquier(dot)xyz>         2018-04-18 02:16:52 from Andres Freund <andres(at)anarazel(dot)de>          2018-04-18 14:11:44 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>           2018-04-19 00:58:18 from Michael Paquier <michael(at)paquier(dot)xyz>            2018-04-19 19:56:59 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>             2018-04-19 20:06:45 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>             2018-04-19 20:23:58 from Andres Freund <andres(at)anarazel(dot)de>              2018-04-19 20:38:02 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>     2018-04-18 15:44:53 from Simon Riggs <simon(at)2ndquadrant(dot)com>     2018-11-15 05:48:00 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>      2018-11-15 08:59:36 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>       2018-11-15 10:11:03 from Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>        2018-11-15 10:41:35 from Michael Paquier <michael(at)paquier(dot)xyz>        2019-01-17 00:42:14 from "Jamison, Kirk" <k(dot)jamison(at)jp(dot)fujitsu(dot)com>         2019-02-01 02:05:51 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎          2019-02-01 05:02:54 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎           2019-02-01 07:01:59 from "Jamison, Kirk" <k(dot)jamison(at)jp(dot)fujitsu(dot)com>            2019-02-01 07:08:28 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>            2019-02-01 08:11:50 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>             2019-02-01 08:26:58 from Michael Paquier <michael(at)paquier(dot)xyz>              2019-02-04 00:24:47 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>               2019-02-21 16:32:17 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                2019-02-22 02:38:56 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                 2019-02-22 04:47:52 from Michael Paquier <michael(at)paquier(dot)xyz>                 2019-02-22 09:24:32 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                  2019-02-25 02:38:05 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎                   2019-02-25 06:56:31 from Michael Paquier <michael(at)paquier(dot)xyz>                    2019-02-25 06:59:21 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                     2019-02-25 09:16:27 from Michael Paquier <michael(at)paquier(dot)xyz>                      2019-02-25 10:01:08 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                       2019-02-25 10:17:02 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                        2019-02-26 06:29:21 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                         2019-02-26 07:56:37 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                          2019-02-28 00:48:18 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎                    2019-02-25 07:47:28 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                     2019-02-25 09:25:07 from Michael Paquier <michael(at)paquier(dot)xyz>                      2019-02-27 15:55:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                       2019-02-28 01:05:07 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                        2019-02-28 02:24:22 from Michael Paquier <michael(at)paquier(dot)xyz>                         2019-02-28 03:41:03 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                          2019-02-28 05:14:41 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                           2019-02-28 05:54:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                            2019-02-28 19:55:37 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                             2019-02-28 22:17:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                           2019-02-28 07:32:41 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                           2019-02-28 07:50:28 from Sergei Kornilov <sk(at)zsrv(dot)org>                           2019-02-28 08:16:14 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                            2019-02-28 08:33:02 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>                            2019-03-01 18:43:35 from Robert Haas <robertmhaas(at)gmail(dot)com>                             2019-03-01 19:06:01 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                             2019-03-01 19:14:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                              2019-03-01 19:26:44 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                               2019-03-01 19:34:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                2019-03-04 05:18:48 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                 2019-03-04 20:03:37 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>                                  2019-03-04 20:11:12 from Andres Freund <andres(at)anarazel(dot)de>                                   2019-03-04 21:40:53 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>                                    2019-03-04 21:43:50 from Andres Freund <andres(at)anarazel(dot)de>                                     2019-03-04 22:00:47 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>                                      2019-03-04 22:05:15 from Andres Freund <andres(at)anarazel(dot)de>                                       2019-03-04 22:20:39 from "Bossart, Nathan" <bossartn(at)amazon(dot)com>                                   2019-03-05 02:41:35 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                    2019-03-25 08:44:23 from David Steele <david(at)pgmasters(dot)net>                                     2019-03-26 07:56:04 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                      2019-03-26 13:30:28 from Robert Haas <robertmhaas(at)gmail(dot)com>                                       2019-03-26 15:23:11 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                        2019-03-26 17:30:13 from Robert Haas <robertmhaas(at)gmail(dot)com>                                         2019-03-27 01:16:54 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                          2019-03-27 02:35:03 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                           2019-03-27 21:27:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                                            2019-03-28 02:44:02 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                             2019-04-03 13:47:54 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>                                              2019-04-04 04:25:36 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎                                               2019-04-04 11:19:03 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                2019-04-04 13:06:47 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                 2019-04-05 01:14:47 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> 📎                                                 2019-04-05 01:14:50 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                  2019-04-05 17:03:49 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                   2019-04-05 18:11:38 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                    2019-04-05 19:28:00 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                     2019-04-06 15:24:11 from Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>                                                    2019-04-05 19:28:35 from Adrien Mobile <adrien(dot)nayrat(at)anayrat(dot)info>                                                     2019-04-05 19:30:20 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                      2019-04-06 07:53:07 from Darafei Praliaskouski <me(at)komzpa(dot)net>                                                   2019-04-08 00:52:27 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com> 📎                                                    2019-04-08 00:57:40 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                    2019-04-08 01:08:22 from Andres Freund <andres(at)anarazel(dot)de>                                                     2019-04-08 01:16:31 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                                      2019-04-08 03:48:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                       2019-04-08 03:56:52 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                                        2019-04-08 04:38:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                         2019-04-08 04:43:45 from 'Andres Freund' <andres(at)anarazel(dot)de>                                                         2019-04-08 04:51:50 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                          2019-04-08 05:22:17 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                                           2019-04-08 06:01:46 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>                                                            2019-04-08 06:57:59 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                             2019-04-08 08:15:17 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>                                                              2019-04-08 08:20:27 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                               2019-04-08 08:23:59 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>                                                                2019-04-08 11:53:35 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                2019-04-09 00:23:45 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>                                                              2019-04-08 08:26:15 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                               2019-04-08 10:22:04 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com> 📎                                                                2019-04-08 10:29:51 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                 2019-05-07 08:26:59 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>                                                                  2019-05-07 17:14:04 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>                                                                   2019-05-09 21:07:28 from Bruce Momjian <bruce(at)momjian(dot)us>                                                                2019-04-08 11:15:24 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                 2019-05-07 17:16:16 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>                                                                2019-04-09 04:06:26 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                                                 2019-04-09 17:00:03 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>                                                                  2019-04-10 01:58:42 from Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>                                                                2019-05-01 16:11:51 from Andres Freund <andres(at)anarazel(dot)de>                                                        2019-04-08 04:43:38 from Michael Paquier <michael(at)paquier(dot)xyz>                       2019-03-01 19:09:28 from Andres Freund <andres(at)anarazel(dot)de>                        2019-03-01 19:17:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2019-03-01 19:21:24 from Andres Freund <andres(at)anarazel(dot)de>                          2019-03-01 19:29:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>  2018-04-18 14:29:35 from Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>   2018-04-18 17:20:15 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>    2018-04-18 17:42:40 from Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>     2018-04-18 18:13:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2018-04-18 19:33:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>  2018-04-19 05:32:44 from "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
Lists:	pgsql-hackers

In response to

• Re: Re: reloption to prevent VACUUM from truncating empty pages at the end of relation at 2019-04-08 00:52:27 from Fujii Masao

Responses

• RE: reloption to prevent VACUUM from truncating empty pages at the end of relation at 2019-04-08 01:16:31 from Tsunakawa, Takayuki

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Tsunakawa, Takayuki	2019-04-08 01:16:31	RE: reloption to prevent VACUUM from truncating empty pages at the end of relation
Previous Message	Andres Freund	2019-04-08 01:04:27	Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits