Postgres Pro
Downloads
Home   >   mailing lists

work_mem + refresh mat view concurrently performance - Mailing list pgsql-admin

From Wells Oliver
Subject work_mem + refresh mat view concurrently performance
Date
Msg-id CAOC+FBWx7nWPWZdiEMGPOFv9dWZvJK=xu_6WjNpvdcZwYsD5Uw@mail.gmail.com
Whole thread Raw
Responses Re: work_mem + refresh mat view concurrently performance
work_mem + refresh mat view concurrently performance
List pgsql-admin
Tree view
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.

--

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Error LOG: could not receive data from client: Connection reset by peer
Next
From: Laurenz Albe
Date:
Subject: Re: work_mem + refresh mat view concurrently performance