Partitioning table on tztsrange

Alexandre Lessard <[email protected]> Thu, 11 Apr 2019 10:05:13 -0400
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]>
Hi psql users,

I'm looking into implementing a partitioning solution for one of our 
table that has a lot of data. The catch here is that our filter index is 
on a tstzrange and all our code is using the range functions to filter 
the data.

I'd like to know if it's possible to use a tstzrange as the partition 
key column and if so, how is it configured on the sub tables for the limits.

What I'd like to do is configure the partitions on the lower value of 
the tstzrange.

Thanks for your help.

Alexandre Lessard
Mapgears