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