| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Decoupling antiwraparound autovacuum from special rules around auto cancellation |
| Date: | 2023-01-25 09:19:04 |
| Message-ID: | 20230125091904.a7i4hiuhlvjnjlre@awork3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On 2023-01-24 20:59:04 -0800, Andres Freund wrote:
> I find this to be awkward code. The booleans are kinda pointless, and the
> tableagevac case is hard to follow because trigger is set elsewhere.
>
> I can give reformulating it a go. Need to make some food first.
Here's a draft of what I am thinking of. Not perfect yet, but I think it looks
better.
The pg_stat_activity output looks like this right now:
autovacuum due to table XID age: VACUUM public.pgbench_accounts (to prevent wraparound)
Why don't we drop the "(to prevent wraparound)" now?
And I still think removing the "table " bit would be an improvement.
Greetings,
Andres Freund
| Attachment | Content-Type | Size |
|---|---|---|
| v3-autovac-trigger-wip.diff | text/x-diff | 12.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2023-01-25 09:51:03 | Re: Progress report of CREATE INDEX for nested partitioned tables |
| Previous Message | David Rowley | 2023-01-25 09:03:51 | Re: heapgettup() with NoMovementScanDirection unused in core? |