Can you please let us know if Sub-partitions are supported in PGSQL (declarative partitions) 10.1. If yes can it be list-list partitions. We have a situation where a table is very big having around 2 billion rows and is growing. We want to use partitions but not sure if sub-partitions are available. The partition key we are looking for is having around 8000 different values so it will be 8000 partitions and I think that number is really too big number of partitions. For your information RDBMS is not yet Postgres, we are evaluating it to see if it can support. Please suggest.
Regards,
Virendra
This message is intended only for the use of the addressee and may contain information that is PRIVILEGED AND CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify the sender immediately. Thank you.