From: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> |
---|---|
To: | Ivan Kartyshov <i(dot)kartyshov(at)postgrespro(dot)ru> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] WIP: long transactions on hot standby feedback replica / proof of concept |
Date: | 2018-08-10 14:07:24 |
Message-ID: | CAPpHfdvLf4NgKPurqwgJdsOG3ta49XZ-Kp+9mUxOoLaw0bwb9w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi!
On Thu, Aug 9, 2018 at 11:26 PM Ivan Kartyshov
<i(dot)kartyshov(at)postgrespro(dot)ru> wrote:
> Alexander Korotkov писал 2018-06-20 20:54:
> > Thinking about that more I found that adding vacuum mark as an extra
> > argument to LockAcquireExtended is also wrong. It would be still hard
> > to determine if we should log the lock in LogStandbySnapshot(). We'll
> > have to add that flag to shared memory table of locks. And that looks
> > like a kludge.
> >
> > Therefore, I'd like to propose another approach: introduce new lock
> > level. So, AccessExclusiveLock will be split into two
> > AccessExclusiveLocalLock and AccessExclusiveLock. In spite of
> > AccessExclusiveLock, AccessExclusiveLocalLock will be not logged to
> > standby, and used for heap truncation.
> >
> > I expect some resistance to my proposal, because fixing this "small
> > bug" doesn't deserve new lock level. But current behavior of
> > hot_standby_feedback is buggy. From user prospective,
> > hot_standby_feedback option is just non-worker, which causes master to
> > bloat without protection for standby queries from cancel. We need to
> > fix that, but I don't see other proper way to do that except adding
> > new lock level...
>
> Your offer is very interesting, it made patch smaller and more
> beautiful.
> So I update patch and made changes accordance with the proposed concept
> of
> special AccessExclusiveLocalLock.
> I would like to here you opinion over this implementation.
In general this patch looks good for me. It seems that comments and
documentation need minor enhancements. I'll make them and post the
revised patch.
------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Arthur Zakirov | 2018-08-10 14:19:19 | Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors |
Previous Message | Tom Lane | 2018-08-10 13:47:09 | Re: Constraint documentation |