Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres partition max limit - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Postgres partition max limit
Date
Msg-id a1e6dd08f588e111ef0c9e587d7e6a4c09e5e799.camel@cybertec.at
Whole thread Raw
In response to Postgres partition max limit  (Daulat <daulat.dba@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Daulat
Date:
Subject: Postgres partition max limit
Next
From: Laurenz Albe
Date:
Subject: Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"