Supartitions in PGSQL 10 - Mailing list pgsql-general

From Kumar, Virendra
Subject Supartitions in PGSQL 10
Date
Msg-id 63b460f60f93466795e01297e8c21cde@USFKL11XG20CN01.mercer.com
Whole thread Raw
Responses Re: Supartitions in PGSQL 10  (Thomas Kellerer <spam_eater@gmx.net>)
Re: Supartitions in PGSQL 10  (Andrew Staller <andrew@timescale.com>)
List pgsql-general

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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Pg Upgrade failing as it is not able to start and stop server properly
Next
From: Thomas Kellerer
Date:
Subject: Re: Supartitions in PGSQL 10