Re: work_mem + refresh mat view concurrently performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux