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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Adrien Mobile <adrien(dot)nayrat(at)anayrat(dot)info>
Cc: Julien Rouhaud <rjuju123(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, David Steele <david(at)pgmasters(dot)net>, Andres Freund <andres(at)anarazel(dot)de>, "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: Re: reloption to prevent VACUUM from truncating empty pages at the end of relation
Date: 2019-04-05 19:30:20
Message-ID: CA+TgmoYjYRcD6J=KHpz7OXcpGiPvicSybomNEgGXtAfs-tSjiQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Apr 5, 2019 at 3:28 PM Adrien Mobile <adrien(dot)nayrat(at)anayrat(dot)info> wrote:
> How about TRIM?

The problem, in my view, is not that there is anything ipso facto
wrong with SHRINK. The problem is that it's a turn term that has only
de minimis use up until now. Replacing it with some other term that
has never before been used to refer to the behavior under discussion
does not, in my view, fix anything.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2019-04-05 19:32:00 Re: New vacuum option to do only freezing
Previous Message Adrien Mobile 2019-04-05 19:28:35 Re: Re: reloption to prevent VACUUM from truncating empty pages at the end of relation