Re: Large number of partitions of a table - Mailing list pgsql-admin

From Victor Sudakov
Subject Re: Large number of partitions of a table
Date
Msg-id YeT78eAcLCmn5zdL@admin.sibptus.ru
Whole thread Raw
In response to Re: Large number of partitions of a table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Large number of partitions of a table
Next
From: Victor Sudakov
Date:
Subject: Re: Large number of partitions of a table