Message-ID: <d02752b630d6a7dc6c20f2fbca521d66ef9b7568.camel@cybertec.at>
Subject: Re: Table size is constantly growing and causing performance
 problems
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: srinivasan s <srinioracledba7@gmail.com>, Mahesh Shetty
	 <maheshetty20@gmail.com>
Cc: shammat@gmx.net, pgsql-admin@lists.postgresql.org
Date: Wed, 12 Feb 2025 21:40:30 +0100
In-Reply-To: 
 <CAOEeMcWa1v0trGBKnCqOXtsnmH=cGYMq8xKD-RzFaWMh5C-jdg@mail.gmail.com>
References: 
	<CAOEeMcVpRyRkXwFiyks9a_N1_2E2gYdx=0d=b3iq3ccNPza_aA@mail.gmail.com>
	 <2f93346f-645f-46a0-9cad-c913537b5eed@gmx.net>
	 <CAOEeMcVh45Z900bYn25SHKgsy8SCAJ1hE+Q+jhWSzFU__PuELA@mail.gmail.com>
	 <CAJPiW+iM0Kua9G79AELF287Zpp8=dPEirV2OnaJ5GeRVcYvUJw@mail.gmail.com>
	 <CAOEeMcUrw_32bpEQ_oB5o2tnxCQEvC_cMrm+6dt5d0T7tH-aJw@mail.gmail.com>
	 <CAOEeMcXoMu-3z13-y1E7m-1gDty0bO3+0sARfw17ge7baLYZGA@mail.gmail.com>
	 <CAJPiW+gJOHxKh8XpUJvo1nYbAaZx7vFbEa1GXBtJd3a7N1XiQA@mail.gmail.com>
	 <CAOEeMcWa1v0trGBKnCqOXtsnmH=cGYMq8xKD-RzFaWMh5C-jdg@mail.gmail.com>
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/d02752b630d6a7dc6c20f2fbca521d66ef9b7568.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-02-12 at 22:12 +0530, srinivasan s wrote:
> What is the functional difference between regular autovaccum and autovacc=
um (to prevent wrap around)=C2=A0

The latter will want to visit all pages that are not "all frozen", and it
won't silently die if its lock blocks a user process.

Yours,
Laurenz Albe

--=20

*E-Mail Disclaimer*
Der Inhalt dieser E-Mail ist ausschliesslich fuer den=20
bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat=
=20
dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte,=20
dass jede Form der Kenntnisnahme, Veroeffentlichung, Vervielfaeltigung oder=
=20
Weitergabe des Inhalts dieser E-Mail unzulaessig ist. Wir bitten Sie, sich=
=20
in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen.

*CONFIDENTIALITY NOTICE & DISCLAIMER
*This message and any attachment are=20
confidential and may be privileged or otherwise protected from disclosure=
=20
and solely for the use of the person(s) or entity to whom it is intended.=
=20
If you have received this message in error and are not the intended=20
recipient, please notify the sender immediately and delete this message and=
=20
any attachment from your system. If you are not the intended recipient, be=
=20
advised that any use of this message is prohibited and may be unlawful, and=
=20
you must not copy this message or attachment or disclose the contents to=20
any other person.