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
Date: Mon, 17 Jan 2022 05:17:37 +0000
Message-ID: <YeT78eAcLCmn5zdL@admin.sibptus.ru> (raw)
In-Reply-To: <3919502.1642393668@sss.pgh.pa.us>
References: <YeTYA63gEXNePfkv@admin.sibptus.ru>
<3919502.1642393668@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vas@sibptus.ru, pgsql-admin@lists.postgresql.org, tgl@sss.pgh.pa.us
Subject: Re: Large number of partitions of a table
In-Reply-To: <YeT78eAcLCmn5zdL@admin.sibptus.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox