RES: Supartitions in PGSQL 10

> 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

Look:
https://www.depesz.com/2017/02/06/waiting-for-postgresql-10-implement-table-
partitioning/