Re: work_mem + refresh mat view concurrently performance

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: work_mem + refresh mat view concurrently performance
Date: 2023-06-22 16:08:59
Message-ID: 8fbe0d5300f4c37c75c244b0d228d906a78e9a8c.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wetmore, Matthew (CTR) 2023-06-22 16:49:47 work_mem + refresh mat view concurrently performance
Previous Message Wells Oliver 2023-06-22 16:02:27 work_mem + refresh mat view concurrently performance