I am trying to understand any limits (either exact or practical) that exist on the number of partitions for a single Postgres database, and any performance concerns that arise as you approach these limits. To this end, please answer the following related questions:

1. What is the maximum total number of partitions a database can hold?

2. If I am planning to have more than 10,000 partitions in my database, is there anything I should be concerned about?

3. Is there any number of partitions at which concerns arise solely because of the sheer number of partitions and, if so, approximately what number of partitions do these concerns arise at?