| From: | Alexandre Lessard <alessard(at)mapgears(dot)com> |
|---|---|
| To: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Partitioning table on tztsrange |
| Date: | 2019-04-11 14:05:13 |
| Message-ID: | ab10cb25-a779-512b-5934-d8711db40496@mapgears.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Voillequin, Jean-Marc | 2019-04-19 13:04:37 | xpath insert unexpected newlines |
| Previous Message | Debajyoti Saha | 2019-03-29 08:11:17 | returning multiple refcursors from inner function |