Partitioning table on tztsrange - Mailing list pgsql-sql

From Alexandre Lessard
Subject Partitioning table on tztsrange
Date
Msg-id ab10cb25-a779-512b-5934-d8711db40496@mapgears.com
Whole thread Raw
List pgsql-sql
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




pgsql-sql by date:

Previous
From: Debajyoti Saha
Date:
Subject: returning multiple refcursors from inner function
Next
From: "Voillequin, Jean-Marc"
Date:
Subject: xpath insert unexpected newlines