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 1gTkaB-0004Rc-5D for pgsql-admin@arkaria.postgresql.org; Mon, 03 Dec 2018 09:32:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gTka9-00010Q-RL for pgsql-admin@arkaria.postgresql.org; Mon, 03 Dec 2018 09:32:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gTfL7-00039D-T1 for pgsql-admin@lists.postgresql.org; Mon, 03 Dec 2018 03:56:10 +0000 Received: from mail-it1-x12e.google.com ([2607:f8b0:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gTfL0-0004S7-JO for pgsql-admin@lists.postgresql.org; Mon, 03 Dec 2018 03:56:08 +0000 Received: by mail-it1-x12e.google.com with SMTP id m8so7309190itk.0 for ; Sun, 02 Dec 2018 19:56:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:date:subject:message-id :to; bh=QL0E4dXU4ktI0suA0uaSQWPWmXHEJSzvcpcOEGLa13A=; b=J9GWwyFvWz+NXrhn785SjHWiSZIs1SOycbnwV+RXN9nPPzz7VqTN3HXFqU8uUD9XLu rDoplmmYZHmTXRcRScT63QyDqlNI8mrXr85TbT233xRz1eaq31qcDcDs/l4knXczRFXG c3zK632X0HHNtDLBLzjS7xwYiDc+1uxWOStE5R/PDLKsC0CvOH8DR1wAkzaMkmc0oKV6 lgbml5emMbi4/rkpAAPnju/yaS1qJVBvPoMgGWMep+pWGL/M3QNp53wfT4dft24xQV28 xAJIx9cxmdsuh6YHG9H8gmXKXoHrnrAuw83mVoIU7iR03lPSDhZ2Iw29B3aJH5ofOT/F 706Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version:date :subject:message-id:to; bh=QL0E4dXU4ktI0suA0uaSQWPWmXHEJSzvcpcOEGLa13A=; b=fui6ZhU4bHIarlBpitmXa/U2PV9wMx82Qh4djCvPbidKG6rdkZ99o7O4iiOD+EH4m0 uCy4b4qzCLqwIK8PB2E6iIHKlZYNqPvGMzVip5scx7cAw0pSJ8xZP1MM8bI/zxouHBx2 AHuHbhHjwq46xK8KPEX6UHSOXFu0dmYMx2xvTp37isHA1IwJtEYjEjK0oiV4ucc7Mv9+ wrfB4e/zRMN8JSLjmlfbSLQgIuqp3lD6Sf+6pkCxdF2jKGt1NEgt4FyLr8VVBm2g3xPW a0S2b6KFzOEpWH50Jf8P8hiFV9R/OLgVsrQlbGdBbYm76Yo4HMPz5QDIfKArtcP6myRR ODPw== X-Gm-Message-State: AA+aEWYro1tPbDky39sIyJ96SprdNjB/UhAvmeCvpw52rSTvtICzzRqF axz0ynrSN8mn9OBXwJajS89cy+M/ X-Google-Smtp-Source: AFSGD/XOJxZYCAISn5WqEtimR/F6bwDNriwwYDP89PVz2ea4GzruDJsl78o8yXbIvWYHie3D3PSMaQ== X-Received: by 2002:a05:660c:fd2:: with SMTP id m18mr6748406itn.1.1543809361201; Sun, 02 Dec 2018 19:56:01 -0800 (PST) Received: from [172.16.3.133] ([67.148.93.60]) by smtp.gmail.com with ESMTPSA id d192sm5235520iog.81.2018.12.02.19.55.59 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 02 Dec 2018 19:56:00 -0800 (PST) From: Natalie Wenz Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (1.0) Date: Sun, 2 Dec 2018 21:55:57 -0600 Subject: Logical replication and xids Message-Id: To: pgsql-admin@lists.postgresql.org X-Mailer: iPhone Mail (16A404) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk How is the initial snapshot executed in Postgres 10 logical replication? Mai= nly, I=E2=80=99m wondering if it would hold open a transaction id on the pub= lishing database the entire time.=20 (I=E2=80=99m dealing with several databases that are quite large with tables= I want to replicate that are up to 4 or 5 TB, and I=E2=80=99m worried about= running out of xids while the initial snapshot is sent.) Thank you, Natalie=