Re: work_mem + refresh mat view concurrently performance - Mailing list 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