MIME-Version: 1.0
References: <CA+TgmoY3m3RimCHifQnxU3YDVV7oYRbRUX4GZ4FuYkhnhe0giA@mail.gmail.com>
 <20220203215048.rmwjzixdzaetedxq@alap3.anarazel.de> <CAFBsxsHp3brGqWu5vU_6d5wfOU5i40c8u3Hg=3TtN4qZwmAecw@mail.gmail.com>
 <CAH2-WzkEStBgnk0buJYAKw5jpRYUE+-tuLYn5U+vDyhXNfu+DQ@mail.gmail.com>
 <CAFBsxsFiMPxQ-dHZ8tOgktn=+ffeJT3+GinZ4zdOGbmAnCYadA@mail.gmail.com>
 <CAH2-WzkpZcat1YmEVAKpcMBaWRXUd2vGVKHtrBjzBGDL=j6mbA@mail.gmail.com>
 <CAD21AoCAKf+yq8pHLpmyxxS=A5zNFUvxTeergLOhobjYaJbF+Q@mail.gmail.com>
 <CAH2-Wznb+W7HdrcT7vLe5hvxA131ay2EwdY+r3z8Uehd_Jr5uw@mail.gmail.com>
 <CA+Tgmoadjx+r8_gGbbnNifL6vEyjZntiQRPzyixrUihvtZ5jdQ@mail.gmail.com>
 <CAH2-Wz=5RuakSPA9euKmUCa3WX5HB2GFeLd7xKXyH5AwbpCGtg@mail.gmail.com>
 <20220216181846.4syh3mnq5qzjrdiz@alap3.anarazel.de> <CAH2-Wz=gkPvzf+H6nXtcxT2STGvh7-hmys4X-oGsihddZQte1Q@mail.gmail.com>
 <CAH2-Wzkb2ixRbxNsUZ2PA5-uqSh4+Xfq-NmcEKD=JNcncyDPTA@mail.gmail.com>
In-Reply-To: <CAH2-Wzkb2ixRbxNsUZ2PA5-uqSh4+Xfq-NmcEKD=JNcncyDPTA@mail.gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
Date: Wed, 16 Feb 2022 15:11:56 -0500
Message-ID: <CA+TgmoZm0CaokNO0huzRE7t_GaqA4=YRcRHEpxW=rOyqtHozBw@mail.gmail.com>
Subject: Re: do only critical work during single-user vacuum?
To: Peter Geoghegan <pg@bowt.ie>
Cc: Andres Freund <andres@anarazel.de>, Masahiko Sawada <sawada.mshk@gmail.com>, 
	John Naylor <john.naylor@enterprisedb.com>, 
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: <https://www.postgresql.org/message-id/CA%2BTgmoZm0CaokNO0huzRE7t_GaqA4%3DYRcRHEpxW%3DrOyqtHozBw%40mail.gmail.com>
Precedence: bulk

On Wed, Feb 16, 2022 at 2:18 PM Peter Geoghegan <pg@bowt.ie> wrote:
> It seems as if the advice about single user mode persisted for no
> great reason at all. Technically there were some remaining reasons to
> keep it around (like the truncation thing), but overall these
> secondary reasons could have been addressed much sooner if somebody
> had thought about it.

I raised it on the list a couple of years ago, actually. I think I had
a bit of difficulty convincing people that it wasn't something we had
to keep recommending.

-- 
Robert Haas
EDB: http://www.enterprisedb.com