Date: Mon, 17 Jan 2022 05:17:37 +0000
From: Victor Sudakov <vas@sibptus.ru>
To: pgsql-admin@lists.postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Large number of partitions of a table
Message-ID: <YeT78eAcLCmn5zdL@admin.sibptus.ru>
References: <YeTYA63gEXNePfkv@admin.sibptus.ru>
 <3919502.1642393668@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <3919502.1642393668@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/YeT78eAcLCmn5zdL%40admin.sibptus.ru>
Precedence: bulk

Tom Lane wrote:
> Victor Sudakov <vas@sibptus.ru> writes:
> > Do you have success (or disaster) stories for having a large number of
> > partitions in a table (like maybe 10000) in a production database?
> > I've found a great article
> > https://www.depesz.com/2021/01/17/are-there-limits-to-partition-counts/
> > and basically it says 70000 partitions are OK but would like to hear
> > more opinions especially from production experience.
> 
> One thing that cannot be said too strongly is that it depends A LOT
> on which Postgres major version you are working with.  

Sorry, I should have mentioned this. I'm talking about 13.5.

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