Re: work_mem + refresh mat view concurrently performance

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: work_mem + refresh mat view concurrently performance
Дата
Msg-id 8fbe0d5300f4c37c75c244b0d228d906a78e9a8c.camel@cybertec.at
обсуждение исходный текст
Ответ на work_mem + refresh mat view concurrently performance  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-admin
On Thu, 2023-06-22 at 09:02 -0700, Wells Oliver wrote:
> Is there any relationship here? Wondering if increasing the former to a large
> amount for a session (2gb?) would help the joins/hashing/etc of the mat view refresh.
> Or if this is just nonsense.
>
> Looking for some gains in refreshing if possible.

Sure: if the query runs faster, the view can refresh faster.

Yours,
Laurenz Albe



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

Предыдущее
От: Wells Oliver
Дата:
Сообщение: work_mem + refresh mat view concurrently performance
Следующее
От: "Wetmore, Matthew (CTR)"
Дата:
Сообщение: work_mem + refresh mat view concurrently performance