agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Alexandre Lessard <alessard@mapgears.com>
To: pgsql-sql@lists.postgresql.org
Subject: Partitioning table on tztsrange
Date: Thu, 11 Apr 2019 10:05:13 -0400
Message-ID: <ab10cb25-a779-512b-5934-d8711db40496@mapgears.com> (raw)

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

Message-ID: <ab10cb25-a779-512b-5934-d8711db40496@mapgears.com>
Permalink:  ../ab10cb25-a779-512b-5934-d8711db40496@mapgears.com/
Also on:    postgresql.org/message-id/ab10cb25-a779-512b-5934-d8711db40496@mapgears.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: alessard@mapgears.com, pgsql-sql@lists.postgresql.org
  Subject: Re: Partitioning table on tztsrange
  In-Reply-To: <ab10cb25-a779-512b-5934-d8711db40496@mapgears.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox