public inbox for [email protected]  

help / color / mirror / Atom feed

From: Murthy Nunna <[email protected]>
To: pgsql-admin <[email protected]>
Subject: RE: Vacuum Question
Date: Mon, 22 Sep 2025 20:02:56 +0000
Message-ID: <SJ0PR09MB668856CA64315E24A67F49BBB812A@SJ0PR09MB6688.namprd09.prod.outlook.com> (raw)
In-Reply-To: <CANzqJaCVqWuiRT8jhQy+YVZvf-2aPHJt7QHGCieaLqn0Ovq8eA@mail.gmail.com>
References: <SJ0PR09MB6688E7136F78DDD70C8D1028B812A@SJ0PR09MB6688.namprd09.prod.outlook.com>
	<CANzqJaCVqWuiRT8jhQy+YVZvf-2aPHJt7QHGCieaLqn0Ovq8eA@mail.gmail.com>



From: Ron Johnson <[email protected]>
Sent: Monday, September 22, 2025 10:39 AM
To: pgsql-admin <[email protected]>; Murthy Nunna <[email protected]>
Subject: Re: Vacuum Question


[EXTERNAL] – This message is from an external sender
I think you asked the same question 11 years ago. 😀

  *   Seriously, though, 200GB is less than 1% of 22TB.  There are bigger problems if you're running that razor-thin on disk space.

     *   I have 10 TB disk for WALs which is separate from /pgdata disk. But with the amount of WALs vacuum is generating, even 10 TB could fill up.

  *   Is the transaction rate on the active tables sooo high that there's a real chance of wrap-around?

     *   Given the xid numbers, I would say it is high. It went from 786089 to 965376038 in 12 months

  *   According to my interpretation of the docs, if you VACUUM FREEZE the big static tables, then you won't need to vacuum them again, nor worry about wrap-around problems.

     *   About a year ago, I did pgdump/restore. But I did not perform vacuum though. So, may be I should complete my table by table vacuum at least once then.
https://www.postgresql.org/docs/14/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND<https://urldefens...;
PostgreSQL reserves a special XID, FrozenTransactionId, which does not follow the normal XID comparison rules and is always considered older than every normal XID. Frozen row versions are treated as if the inserting XID were FrozenTransactionId, so that they will appear to be “in the past” to all normal transactions regardless of wraparound issues, and so such row versions will be valid until deleted, no matter how long that is.

reply

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: [email protected]
  Cc: [email protected]
  Subject: RE: Vacuum Question
  In-Reply-To: <SJ0PR09MB668856CA64315E24A67F49BBB812A@SJ0PR09MB6688.namprd09.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox