Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jdzVy-0007r6-SC for pgsql-admin@arkaria.postgresql.org; Wed, 27 May 2020 17:06:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jdzVx-000093-PL for pgsql-admin@arkaria.postgresql.org; Wed, 27 May 2020 17:06:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jdzVx-00008w-53 for pgsql-admin@lists.postgresql.org; Wed, 27 May 2020 17:06:49 +0000 Received: from mail-db8eur05on2050.outbound.protection.outlook.com ([40.107.20.50] helo=EUR05-DB8-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jdzVt-0005gj-To for pgsql-admin@postgresql.org; Wed, 27 May 2020 17:06:48 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=j9LSxL4M5S85k9+DLkP6LxAvB9sabgTEhfhfWs0dTlup2h1x2GJ2r3vrzy5at8LHSfdHKA4X+4COdWr54NB2CrYcBeXEtNMmv6FkWv9+UO7G6ecJ6Cr7ZFuyZOlL8aGsVS+YcNAGlHiXwhMOLJt2bGhASrn07iKbwca4ttEQZFDH0B7Foecfe4t1Cp1dLrZygMTjKQOTDQ6wV+e5dx+ZqP68uqeB9ybvxiIEFe4qh2Suu1jdEeWfNnRIAekUl0PSp4i5UEtIj3ZBRul0ZHnyrooufM514yiYbFpJ9O5US6R6GbMZn2M5ai8yYTf4Ec7kVlo6rF/o0shYoptlWdG3TA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=PJoGAPOXjWJkW0N8nKdiCe6NupNMXYAzw38IRbOxoCo=; b=SJ61haqKCKt79K+Icc+I8NMP5iEiAhTrkjnMvfsFU5tJtpqNdRlkPY3riTX75zWFGtyA5z66qPn5cfbkAMEz/zOYl8DXmwP5k21rKg5sJ8Xv1QN3qzP+wIrjS3iPsfV9uLxPo3wkaTlenJTQJz9eJw7sss+2PDJqvGG5byMOxyV6/ZCY6x1v6GXeg1c66R3eSrxR1izy2tCmwxJNwzOfJ0Bc08ubsJHHER3lktz6fs1zK6KJ5P7S5YcMvu44IjSO9K3PyjEF1XO+2jyeixVC/G4coWYUfBr2/21bOLDTeCHZv7hUul1sw4kLIfoOxNJ3jQtQiYwjnxyx0QKLYlkIuw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucll.be; dmarc=pass action=none header.from=ucll.be; dkim=pass header.d=ucll.be; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucll.be; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=PJoGAPOXjWJkW0N8nKdiCe6NupNMXYAzw38IRbOxoCo=; b=OD5dGMHPhIUsmrggfNDCdN3EiSwyGpKdZmzcwPL0GWfdrQ7ImOzDucCQnw+KrshyViloqRUr+WiLiub2EM+IvpvCDbFlxZt4AoTyuMpO+LqwQ2wUjZvunszSAOPYEhz7/xx/hfkE/UR78JCicfGsd4D4XReisA88lBBnlEprMAc= Authentication-Results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=ucll.be; Received: from AM0P195MB0324.EURP195.PROD.OUTLOOK.COM (2603:10a6:208:b3::30) by AM0P195MB0530.EURP195.PROD.OUTLOOK.COM (2603:10a6:20b:16a::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3045.17; Wed, 27 May 2020 17:06:44 +0000 Received: from AM0P195MB0324.EURP195.PROD.OUTLOOK.COM ([fe80::54b6:3cdc:b493:6760]) by AM0P195MB0324.EURP195.PROD.OUTLOOK.COM ([fe80::54b6:3cdc:b493:6760%7]) with mapi id 15.20.3021.029; Wed, 27 May 2020 17:06:44 +0000 Message-ID: <5294e137525806ff1ae7e2a0bb23a7db2594e1b7.camel@ucll.be> Subject: maximum number of subscriptions from the subscriber side From: Wim Bertels Reply-To: wim.bertels@ucll.be To: pgsql-admin Date: Wed, 27 May 2020 19:06:42 +0200 Organization: UC Leuven-Limburg Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.30.5-1.1 Content-Transfer-Encoding: 7bit X-ClientProxiedBy: AM3PR03CA0061.eurprd03.prod.outlook.com (2603:10a6:207:5::19) To AM0P195MB0324.EURP195.PROD.OUTLOOK.COM (2603:10a6:208:b3::30) MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from ptr-7u36h5k51lesqlynxiz.18120a2.ip6.access.telenet.be (2a02:1811:526:1700:60e:3cff:feb0:7f7b) by AM3PR03CA0061.eurprd03.prod.outlook.com (2603:10a6:207:5::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3045.19 via Frontend Transport; Wed, 27 May 2020 17:06:43 +0000 X-Originating-IP: [2a02:1811:526:1700:60e:3cff:feb0:7f7b] X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 9afa67bc-5c10-496e-2b5f-08d8026054f0 X-MS-TrafficTypeDiagnostic: AM0P195MB0530: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:8882; X-Forefront-PRVS: 04163EF38A X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: VxieLvBWj5+ruOnlYyZGTgMD86NHBqQnFif3nihI8mjyKnjyd19eXeYo/Ma2L/U6j/IoLgiXtc1M97KdPood2zduppolMi0Xa4lQDoPLxOx4KRH/aHFMHKb+zcd4D6R7e3HzeDUXdZmcTvnTyYxwdMSVFbvxokmnHWwTiLjbqAOUzMvkDtZAx+NRRC/anlFRph4aX4/KNjtadlPsKZYKsOYmWXdhd0j7lg2iSonVHmJnVs5fFtvE1NgrIh60h/Mfv0tpDoCt8QfYHARW26TYyl1IPcfWM+FT8E4c75qdciPsUwkIUxK6CW6kyN34LoA350UeMSYziqQ2UwGx3o9WdYqIWJ36qxLCW8Z1hEn/IBXzFwi5d03k1pSNs+yc+T0OAuAh0Fe4aMrGXMICvLCbrQ== X-Forefront-Antispam-Report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AM0P195MB0324.EURP195.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFTY:;SFS:(4636009)(366004)(396003)(39850400004)(346002)(136003)(376002)(966005)(8676002)(8936002)(44832011)(2616005)(6916009)(86362001)(6512007)(2906002)(52116002)(6486002)(6506007)(36916002)(316002)(83380400001)(478600001)(786003)(66476007)(36756003)(66556008)(16526019)(186003)(3450700001)(5660300002)(66946007);DIR:OUT;SFP:1101; X-MS-Exchange-AntiSpam-MessageData: O5MTy+vHQN7xHTuuQRtYV1i2xjajfD7pq4HP0W3y9p1G4qMXH8YsXCAgARFu9Wq1FCttGiGjvHzgG+yr0AgkGHtNpb0gzkMBI9QCIe0Fquj4lfcFvecwpHSTrsEGg+m65VZEcpnV6KZpgRslEiaYxh/stQ7/zZfPAccsqKaL4CKz8+htzwCNWMIhpcY9b2NASeMT1uyDMBj94m7ti3FkOklRRTj4h4QduiXk1UXWqaF5DImYM/xy1UBbJTAAN2mh17ABkPa+N//8JG/WfL7xP/erSillb20bLaVZH6/C5OIOg0hlaj/uRTlJYZ0UMSFpcLZ0V1k/C/rdkJezDMbqVYCDyOCgxc6bms63srpaRdpq6eFMN5Hr4EdJct7OBrFpCmihulEtwpo18wxohvT17ZX4eCWukBtcz8RaIRBRrCCQzP9cc+r/rdOSfNbrxhSPVtqjGkKVqf0p4yR7Y5cnOF91O9pjYI2NNNO0OoCmFV8Mj3UDpBC8EHz0MaPKyz8w0ocVpaUZTS/caz2KJFMlqC/rSEwLj71RKySJX+BUs7g= X-OriginatorOrg: ucll.be X-MS-Exchange-CrossTenant-Network-Message-Id: 9afa67bc-5c10-496e-2b5f-08d8026054f0 X-MS-Exchange-CrossTenant-OriginalArrivalTime: 27 May 2020 17:06:44.0735 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: e638861b-15d9-4de6-a65d-b48789ae1f08 X-MS-Exchange-CrossTenant-MailboxType: HOSTED X-MS-Exchange-CrossTenant-UserPrincipalName: XWR5kXI3fzJOScQayIvcbrv7h5Yz8MDEyGmOcZvTzBDGrhLLJBFihUVXt5mT9Ojp0OLDcay/H5JiP3nKIKauGQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM0P195MB0530 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello, Using the built in logical replication. I am trying out a small stress test, with a 100 subscriptions to 1 publication between 2 servers (1 database per subscription on the subscriber side) All the 100 slots are made, visible on the publication and subscription server, but only 10 subscriptions were active at first? Based on: https://www.postgresql.org/docs/current/runtime-config-replication.html point 19.6.4 i have adapted these settings in the subscription side: max_sync_workers_per_subscription | 2 max_logical_replication_workers | 128 max_worker_processes | 136 But i noticed i also needed to change (on the subscriber server): max_replication_slots (default 10) to a least 100 for all the 100 subscriptions to actually work. (otherwise there were only 10 active subscription processes) This wasn't clear for me from the documentation, but probably i missed something? PS: while testing this, the main for the publishing server seems cpu $w 19:03:28 up 15 days, 3:47, 3 users, load average: 46,77, 63,02, 39,37 (in case of a publishing server with very little writes, 4 cores! and 8GB ram; ram seemed fine though) PPS: this is a special use, this not a regular one. -- mvg, Wim