Re: ATTACH/DETACH PARTITION CONCURRENTLY

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: ATTACH/DETACH PARTITION CONCURRENTLY
Date: 2018-11-07 13:58:39
Message-ID: CA+TgmoYiMWXrKNsmawhjLVF5pPq56+Wfkc=1ScrpD0kndXpSDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 6, 2018 at 10:18 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
> > > Throw tuples destined for that partition away?
> > Surely not. (/me doesn't beat straw men anyway.)
>
> Hmm, apparently this can indeed happen with my patch :-(

D'oh. This is a hard problem, especially the part of it that involves
handling detach, so I wouldn't feel too bad about that. However, to
beat this possibly-dead horse a little more, I think you made the
error of writing a patch that (1) tried to solve too many problems at
once and (2) didn't seem to really have a clear, well-considered idea
about what the semantics ought to be.

This is not intended as an attack; I want to work with you to solve
the problem, not have a fight about it.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2018-11-07 14:01:13 Fedora 29 vs linux collation tests
Previous Message Robert Haas 2018-11-07 13:51:25 Re: Connection limit doesn't work for superuser