On Wed, Sep 6, 2023 at 5:27 PM Daulat wrote:
> Hi Team,
>
> Do we have a max limit of partitions for a table in postgres?
>
As far as I can tell, there is no real hard limit to that per se. After
all, you will eventually run out of OIDs for pg_attribute but that would
affect the number of colum
On Wed, 2023-09-06 at 13:35 +0530, Daulat wrote:
> Do we have a max limit of partitions for a table in postgres?
I don't think there is a technical limit.
But as soon as you have more than a few thousand partitions, the
experience won't be that great any more.
Yours,
Laurenz Albe
