Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkQtO-0001xi-TW for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2019 10:29:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hkQtM-0003E2-Mi for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jul 2019 10:29:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkQtM-0003Du-Bf for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2019 10:29:04 +0000 Received: from mail-oi1-x241.google.com ([2607:f8b0:4864:20::241]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hkQtF-000765-6b for pgsql-hackers@lists.postgresql.org; Mon, 08 Jul 2019 10:29:04 +0000 Received: by mail-oi1-x241.google.com with SMTP id m206so12157518oib.12 for ; Mon, 08 Jul 2019 03:28:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=06JyIQp0X0nqwHIk1th9LOMITh+TPNssx/uGigQRn70=; b=tHII4RikJ5MMzpKzgXU/f9d3tBIGF7kH5xZ7ZOOIf7M1CNTuIbXtVBjfRx3BR9eJ1j 8unuuCnX4F2q/MSSfaMC0FSDUAVCGiA/iHhn+3wl+/GBJE1d0Oka8wNdJgvGWL6oA7VA pQa9GWy7r23bnm9U8LS8sDOJJ9/Ae2nOiHLnG6l4ISq2lyCQ51l33/IUDsRhM4IPhC8i Aif5lfOYWk/wPKdcVwt3ROOvyRETQ/x8u85ki2fQWPm8iyBJuUUUHfvqWV30e3mwzMNU S7ROK9pSBtpDvLgl6Lio5b+6zrBradCapxsh07nS8HbU6b2noxDticSYjj889rhEHq27 0+nQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=06JyIQp0X0nqwHIk1th9LOMITh+TPNssx/uGigQRn70=; b=cyuY04wlWKNfYPlCT/hmUnfgNY2+DeTvZ4MX9JLF3X3ew9ZAmp1+bmt0ljx7w5hQgf NKKeEF6G5VVj+qICy7s8AMw/2rONgdM0XXrpkYq5lqFm73jFJ49qPqEzy0qDCiNNZvze dtr/dvv2SL9h/cshG5tg7LdU4aIsGW5DsW+adeC1XxPmKV6gTUbIlESM9CF7GNEDEMwy KY3nFaAjqe3SPohjO9T2FHIaYoMaJeHl3TJNB084mzNVydGmrMW1tTlqI8DPnyq3ssWR IXGICUznjuYpZaDxWqF01edC10bwztZQUqJCiJRyXSC2YwLHmXOl88yERLnU9IJ7D5aM U3PQ== X-Gm-Message-State: APjAAAUewQMHLFHW5r9ZFIuhSj9gWuAkU4x9I36GIf77o/9O6Lmc1qDg UpUGNc58zszfT3C4/OIpw1KTGP+1uvr1ls110okuKowoW/O6RQ== X-Google-Smtp-Source: APXvYqyk1omlDNUOlqieZSKOxdYTuh1fBkzZ6HeFlizSkDCFVlfFaeC8tbyiwX1wlk3GeVeXwTbZ8W2NQ46zgk9zIvM= X-Received: by 2002:aca:cf51:: with SMTP id f78mr8780266oig.10.1562581735011; Mon, 08 Jul 2019 03:28:55 -0700 (PDT) MIME-Version: 1.0 References: <3095349b-44d4-bf11-1b33-7eefb585d578@2ndquadrant.com> In-Reply-To: <3095349b-44d4-bf11-1b33-7eefb585d578@2ndquadrant.com> From: Thomas Munro Date: Mon, 8 Jul 2019 22:28:18 +1200 Message-ID: Subject: Re: Synchronizing slots from primary to standby To: Petr Jelinek Cc: PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, Dec 31, 2018 at 10:23 AM Petr Jelinek wrote: > As Andres has mentioned over at minimal decoding on standby thread [1], > that functionality can be used to add simple worker which periodically > synchronizes the slot state from the primary to a standby. > > Attached patch is rough implementation of such worker. It's nowhere near > committable in the current state, it servers primarily two purposes - to > have something over what we can agree on the approach (and if we do, > serve as base for that) and to demonstrate that the patch in [1] can > indeed be used for this functionality. All this means that this patch > depends on the [1] to work. Hi Petr, Do I understand correctly that this depends on the "logical decoding on standby" patch, but that isn't in the Commitfest? Seems like an oversight, since that thread has a recently posted v11 patch that applies OK, and there was recent review. You patches no longer apply on top though. Would it make sense to post a patch set here including logical-decoding-on-standby_v11.patch + your two patches (rebased), since this is currently marked as "Needs review"? -- Thomas Munro https://enterprisedb.com