Re: PoC: Compute a histogram of prune_xid to support autovacuum improvements

From: Renan Alves Fonseca <renanfonseca(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PoC: Compute a histogram of prune_xid to support autovacuum improvements
Date: 2025-06-05 00:33:09
Message-ID: 8734cfrpru.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Renan Alves Fonseca <renanfonseca(at)gmail(dot)com> writes:

> histogram. In my tests, not always, a small annoying difference shows
> up. Actually, it is really annoying, I'm struggling with it and I hope
> someone helps me to find the missing bits.

Finally, I've found out that this error has been triggered by my test
script. The problem arises when we run an ANALYZE command and there are
pending stats waiting to be flushed. It seems that the pending stats are
completely discarded, which might make sense for other statistics.

Besides that, the patch works as expected.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message jian he 2025-06-05 00:45:10 Re: speedup COPY TO for partitioned table.
Previous Message Michael Paquier 2025-06-05 00:23:42 Re: Partitioned tables and [un]loggedness