Postgres Pro
Downloads
Home   >   mailing lists

Thread: Supartitions in PGSQL 10

Supartitions in PGSQL 10

From
"Kumar, Virendra"
Date:

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.

Re: Supartitions in PGSQL 10

From
Thomas Kellerer
Date:
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

RES: Supartitions in PGSQL 10

From
Márcio A. Sepp
Date:
> 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/

Re: Supartitions in PGSQL 10

From
Andrew Staller
Date:
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