From: | Tim Uckun <timuckun(at)gmail(dot)com> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Choosing an index on partitioned tables. |
Date: | 2021-09-07 09:52:32 |
Message-ID: | CAGuHJrNd7n0d4+Zb+uK6BeEctkKRY2OXgSc39ywciFkFBf+n2Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
It's weird that it's supported on AWS and many other providers but not
in the official docker images.
On Tue, Sep 7, 2021 at 9:16 PM Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>
> On Tue, Sep 7, 2021 at 10:51 AM Tim Uckun <timuckun(at)gmail(dot)com> wrote:
> >
> > To be fair Timescale also adds some other features which might be
> > useful. For example they add some SQL enhancements like last value
> > and auto maintaining materialized views and such. The automatic
> > management of partitions is also pretty big plus in my opinion. You
> > can get some of the equivalent functionality by writing stored procs
> > and deploying pg_cron but it's nice to have those things built in.
>
> If you want automatic partition management, look at pg_partman. No
> need to write your own procs and deploy with cron.
>
> And FWIW, in reference to the discussions about AWS, it is supported on RDS.
>
> --
> Magnus Hagander
> Me: https://www.hagander.net/
> Work: https://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2021-09-07 09:59:44 | Re: Choosing an index on partitioned tables. |
Previous Message | Magnus Hagander | 2021-09-07 09:16:03 | Re: Choosing an index on partitioned tables. |