Supartitions in PGSQL 10
Team,
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. Please suggest.
Regards,
Virendra
________________________________
This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AND CONFIDENTIAL.
If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the message
and its attachments and notify the sender immediately. Thank you.
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
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-DECLARATIVEPartitions 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/
Virenda, is this time-series data you're working with?
On Mon, Jan 8, 2018 at 4:12 PM, Kumar, Virendra <Virendra.Kumar@guycarp.com>
wrote:
Team,
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. Please suggest.Regards,
Virendra
------------------------------
This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AND CONFIDENTIAL.If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the
message
and its attachments and notify the sender immediately. Thank you.
--
TimescaleDB* | *Growth & Developer Evangelism
c: 908.581.9509
335 Madison Ave.
New York, NY 10017
http://www.timescale.com/
https://github.com/timescale/timescaledb