Re: 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

Thomas