| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Supartitions in PGSQL 10 |
| Date: | 2018-01-08 21:15:37 |
| Message-ID: | 45e742f4-c516-08c6-7351-ca26e516085a@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Márcio A. Sepp | 2018-01-08 22:44:40 | RES: Supartitions in PGSQL 10 |
| Previous Message | Kumar, Virendra | 2018-01-08 21:12:15 | Supartitions in PGSQL 10 |