Re: Declarative partitioning and materialized views

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Declarative partitioning and materialized views
Дата
Msg-id 8025740856ba14e672f21f8b89eaf705ca87428c.camel@cybertec.at
обсуждение исходный текст
Ответ на Declarative partitioning and materialized views  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-admin
On Sat, 2020-01-25 at 16:05 -0800, Wells Oliver wrote:
> Hey all. Wondering if partitioning a table might help the speed of refreshing a materialized view that uses that
table?

Probably not, but that depends on the query used to define the view.

If that query becomes faster by partitioning the table, then partitioning will help.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




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

Предыдущее
От: manish yadav
Дата:
Сообщение: Re: EFM Startup Failed
Следующее
От:
Дата:
Сообщение: RE: pg_rewind