| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Peter Geoghegan <pg(at)bowt(dot)ie>, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Noah Misch <noah(at)leadboat(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Marco Nenciarini <marco(dot)nenciarini(at)2ndquadrant(dot)it>, Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] Logical decoding of TRUNCATE |
| Date: | 2020-12-21 17:42:47 |
| Message-ID: | 20201221174247.67pnoem5dtscocv4@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Hi,
On 2020-12-20 15:54:31 -0800, Peter Geoghegan wrote:
> On Sun, Dec 20, 2020 at 3:13 PM Andres Freund <andres(at)anarazel(dot)de> wrote:
> > Hm. Do I understand correctly that this problem is hit solely because
> > the parallel mode code relies on there already have been a transaction
> > snapshot set, thus avoiding the error? And that the code normally only
> > works because GetTransactionSnapshot() will already have been called
> > somewhere, before EnterParallelMode()?
>
> It seems unlikely that InitializeParallelDSM() was ever intended to be
> run in a background worker.
IDK, the environment in a bgworker shouldn't be that different from the
normal query environment in a normal connection. And it's far from
insane to want to be able to run a paralell query in a bgworker (and I
*think* I have seen that work before). This case here seems more like
an accidental dependency than anything to me, once that could perhaps
even hint at problems in normal backends too.
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lars Vonk | 2020-12-21 20:26:00 | Re: Missing rows after migrating from postgres 11 to 12 with logical replication |
| Previous Message | Philip Semanchuk | 2020-12-21 16:45:41 | Re: Avoid excessive inlining? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Surafel Temesgen | 2020-12-21 18:01:23 | Re: WIP: System Versioned Temporal Table |
| Previous Message | Jeff Janes | 2020-12-21 17:26:17 | Re: BUG #16079: Question Regarding the BUG #16064 |