From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: junhkang91@gmail.com
Subject: BUG #18384: It's not bug just question about documentation
Date: Fri, 08 Mar 2024 06:00:16 +0000
Message-ID: <18384-d9f97269de73f0fa@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18384
Logged by: Jun Kang
Email address: junhkang91@gmail.com
PostgreSQL version: 16.2
Operating system: Linux
Description:
I am a big PostgreSQL lover and keep reading documents and implying to
postgresql with bigdata service.
while I am reading
https://www.postgresql.org/docs/16/transaction-id.html
and
https://www.postgresql.org/docs/16/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND,
i have a question.
"The internal transaction ID type xid is 32 bits wide and wraps around every
4 billion transactions."
"it is necessary to vacuum every table in every database at least once every
two billion transactions."
why Postgresql needs to vacuum in every 2B transactions even though txid
wraps on every 4 billion transactions (double time)?
as the freezing issue, isnt it better to reduce vacuum count?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, junhkang91@gmail.com
Subject: Re: BUG #18384: It's not bug just question about documentation
In-Reply-To: <18384-d9f97269de73f0fa@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox