From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
---|---|
To: | Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com> |
Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: error context for vacuum to include block number |
Date: | 2020-03-04 21:51:59 |
Message-ID: | 20200304215159.GA31231@telsasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Mar 04, 2020 at 04:21:06PM +0900, Masahiko Sawada wrote:
> Thank you for updating the patch. But we have two more places where we
> do fsm vacuum.
Oops, thanks.
I realized that vacuum_page is called not only from lazy_vacuum_heap, but also
directly from lazy_scan_heap, which failed to update errcbarg. So I changed to
update errcbarg in vacuum_page.
What about these other calls ? I think granularity of individual function
calls requires a debugger, but is it fine issue if errors here are attributed
to (say) "scanning heap" ?
GetRecordedFreeSpace
heap_*_freeze_tuple
heap_page_prune
HeapTupleSatisfiesVacuum
LockBufferForCleanup
MarkBufferDirty
Page*AllVisible
PageGetHeapFreeSpace
RecordPageWithFreeSpace
visibilitymap_*
VM_ALL_FROZEN
> These functions have LVDeadTuples and LVRelStats but LVDeadTuples can
> be referred by LVRelStats. If we want to use LVRelStats as callback
> argument, we can remove function arguments that can be referred by
> LVRelStats.
That doesn't work easily with parallel vacuum, which passes not
vacrelstats->dead_tuples, but a dead_tuples pulled out of shm_toc.
But it was easy enough to remove "reltuples".
--
Justin
Attachment | Content-Type | Size |
---|---|---|
v24-0001-vacuum-errcontext-to-show-block-being-processed.patch | text/x-diff | 17.4 KB |
v24-0002-Drop-reltuples.patch | text/x-diff | 4.0 KB |
v24-0003-add-callback-for-truncation.patch | text/x-diff | 2.2 KB |
v24-0004-Avoid-some-calls-to-RelationGetRelationName.patch | text/x-diff | 3.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Dilger | 2020-03-04 21:52:56 | Re: New SQL counter statistics view (pg_stat_sql) |
Previous Message | Alvaro Herrera | 2020-03-04 21:33:21 | Re: range_agg |