| From: | Victor Sudakov <vas(at)sibptus(dot)ru> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Large number of partitions of a table |
| Date: | 2022-01-17 05:17:37 |
| Message-ID: | YeT78eAcLCmn5zdL@admin.sibptus.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Tom Lane wrote:
> Victor Sudakov <vas(at)sibptus(dot)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(at)fidonet
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Sudakov | 2022-01-17 05:38:15 | Re: Large number of partitions of a table |
| Previous Message | Ron | 2022-01-17 04:32:38 | Re: Large number of partitions of a table |