Re: Choosing an index on partitioned tables.

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: Choosing an index on partitioned tables.
Дата
Msg-id CAGuHJrNd7n0d4+Zb+uK6BeEctkKRY2OXgSc39ywciFkFBf+n2Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Choosing an index on partitioned tables.  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Choosing an index on partitioned tables.  (Magnus Hagander <magnus@hagander.net>)
Список 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@hagander.net> wrote:
>
> On Tue, Sep 7, 2021 at 10:51 AM Tim Uckun <timuckun@gmail.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/



В списке pgsql-general по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Choosing an index on partitioned tables.
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Choosing an index on partitioned tables.