Partitioning table on tztsrange

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Partitioning table on tztsrange

Alexandre Lessard
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