Kumar, Virendra schrieb am 08.01.2018 um 22:12:
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.
Quote from the manual: https://www.postgresql.org/docs/current/static/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE
Partitions may themselves be defined as partitioned tables, using what is called sub-partitioning
Thomas
