| From: | Jingtang Zhang <mrdrivingduck(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers mailing list <pgsql-hackers(at)lists(dot)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Subject: | Re: [PATCH] Periodically refresh database frozen IDs during autovacuum |
| Date: | 2026-11-02 16:54:45 |
| Message-ID: | CAPsk3_BQFJDocvZqpG12NLt2aLYf4ApFdh541RHcDVnBpYHcOQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Oh, forget about the graph. Attached.
> For testing, I constructed 1,000 tables with different frozen-XID ages,
> all requiring aggressive vacuum, and enabled three autovacuum workers.
> The interval was shortened to ten seconds for this test. As shown in the
> attached figure, without the patch, the maximum table age fell steadily
> while the database age remained flat until all tables finished at about
> 150 seconds. With the patch, the database age followed the declining
> table age, updating roughly every ten seconds.
---
Regards,
Jingtang
| Attachment | Content-Type | Size |
|---|---|---|
| age-comparison.png | image/png | 206.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-11-02 17:01:33 | Re: Remove unused arguments from split_selfjoin_quals() |
| Previous Message | Nathan Bossart | 2026-11-02 16:48:22 | Re: [PATCH] Periodically refresh database frozen IDs during autovacuum |
