> 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/
