work_mem + refresh mat view concurrently performance

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: work_mem + refresh mat view concurrently performance
Date: 2023-06-22 16:02:27
Message-ID: CAOC+FBWx7nWPWZdiEMGPOFv9dWZvJK=xu_6WjNpvdcZwYsD5Uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-06-22 16:08:59 Re: work_mem + refresh mat view concurrently performance
Previous Message Laurenz Albe 2023-06-22 13:51:22 Re: Error LOG: could not receive data from client: Connection reset by peer