From: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
---|---|
To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, 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-25 10:12:29 |
Message-ID: | 20200325101229.GR21443@telsasoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, Mar 25, 2020 at 09:16:46AM +0530, Amit Kapila wrote:
> I think by mistake you have re-introduced this chunk of code. We
> don't need this as we have done it in the caller.
Yes, sorry.
I used too much of git-am and git-rebase to make sure I didn't lose your
changes and instead reintroduced them.
On Wed, Mar 25, 2020 at 02:16:35PM +0900, Masahiko Sawada wrote:
> > > Won't the latest patch by Justin will fix this as he has updated the
> > > block count after count_nondeletable_pages? Apart from that, I feel
> >
> > The issue is if the error happens *during* count_nondeletable_pages().
> > We don't want it to say "truncating relation to 100 blocks".
>
> Right.
>
> > > the first call to update_vacuum_error_cbarg in lazy_truncate_heap
> > > should have input parameter as vacrelstats->nonempty_pages instead of
> > > new_rel_pages to indicate the remaining pages after truncation?
> >
> > Yea, I think that addresses the issue.
Attached patch addressing these.
--
Justin
Attachment | Content-Type | Size |
---|---|---|
v33-0001-Introduce-vacuum-errcontext-to-display-additiona.patch | text/x-diff | 22.4 KB |
v33-0002-Drop-reltuples.patch | text/x-diff | 4.0 KB |
v33-0003-Avoid-some-calls-to-RelationGetRelationName.patch | text/x-diff | 3.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2020-03-25 10:13:19 | Re: potential stuck lock in SaveSlotToPath() |
Previous Message | John Naylor | 2020-03-25 10:04:53 | Re: [proposal] de-TOAST'ing using a iterator |