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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1nA8EY-00073O-M4
	for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jan 2022 10:30:30 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1nA8EX-0004Qu-72
	for pgsql-admin@arkaria.postgresql.org; Wed, 19 Jan 2022 10:30:29 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vas@sibptus.ru>)
	id 1nA8EW-0004Ql-Rb
	for pgsql-admin@lists.postgresql.org; Wed, 19 Jan 2022 10:30:28 +0000
Received: from admin.sibptus.ru ([2001:19f0:5001:21dc::10])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <vas@sibptus.ru>)
	id 1nA8EU-0003kK-Gy
	for pgsql-admin@lists.postgresql.org; Wed, 19 Jan 2022 10:30:27 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=sibptus.ru;
	s=20181118; h=In-Reply-To:Message-ID:Subject:To:From:Date;
	bh=hB3kaYj1xS0qFQiV/2cUuI8lUp23yJZBLVpGFHOWqMc=; b=ongFNdqL06BsxETpea25w3o5z9
	TPy27pbbKCGGyBCMZYuYKVahHHo2jihdbAXWWLH+Kze4eTvQgbEdqLWq2Fr/ctRONlpPxnmlMDYvF
	wrN/Y+I6y4AsnrhK5CvNYEIafzyy0hGsiptOp2eW7ZqrBL5ouxCr0oXnkv1/my/K5/ok=;
Received: from vas by admin.sibptus.ru with local (Exim 4.95 (FreeBSD))
	(envelope-from <vas@sibptus.ru>)
	id 1nA8ET-000KTC-Fm;
	Wed, 19 Jan 2022 10:30:25 +0000
Date: Wed, 19 Jan 2022 10:30:25 +0000
From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Cc: Ketan Popat <ketanpostgres@gmail.com>
Subject: Re: Large number of partitions of a table
Message-ID: <YefoQf/pUb76UQGA@admin.sibptus.ru>
References: <671340a5-1960-e5dc-1d09-4b7f36cda2c8@gmail.com>
 <YeYr88f3jXHlijU9@admin.sibptus.ru>
 <254601.1642480213@sss.pgh.pa.us>
 <YeZV0QSOly8Pnx5d@admin.sibptus.ru>
 <268771.1642489687@sss.pgh.pa.us>
 <YeZ3/4TSd+xHAlDl@admin.sibptus.ru>
 <d45899c8-187d-4a1d-563b-f5842243e770@gmail.com>
 <0fdfb200-9aad-370b-3282-6585158de94f@gmail.com>
 <6cea6b1c-9e12-2771-a2f7-d8a73ce723f3@gmail.com>
 <CAKx+mvaDeH1DYJDwHbei70ZHeYXOnKdNCtJFX7Q+wQxa9TNivQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAKx+mvaDeH1DYJDwHbei70ZHeYXOnKdNCtJFX7Q+wQxa9TNivQ@mail.gmail.com>
X-PGP-Key: http://admin.sibptus.ru/~vas/
X-PGP-Fingerprint: 10E3 1171 1273 E007 C2E9  3532 0DA4 F259 9B5E C634
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/YefoQf/pUb76UQGA%40admin.sibptus.ru>
Precedence: bulk

Ketan Popat wrote:
> Hi Victor,
> 
> Thanks for starting a thread on a large number of partitions with
> PostgreSQL.
> 
> If you are okay, I would like to start with understanding the problem
> rather than the solution.
> What I have understood so far is, you have a multi-tenant application and
> you are using PostgreSQL 13.5 as a data store for the same.
> 
> Few questions there:

Hello Ketan,

I'm sorry this information is too private to share.

-- 
Victor Sudakov VAS4-RIPE
http://vas.tomsk.ru/
2:5005/49@fidonet