[MASSMAIL]Work_mem - Mailing list pgsql-admin

From Rajesh Kumar
Subject [MASSMAIL]Work_mem
Date
Msg-id CAJk5AtYJG_dhkpJQ=vKOnbQmzZhjcFhgxKptbK7L2o67a03zPQ@mail.gmail.com
Whole thread Raw
Responses Re: Work_mem
Re: Work_mem
List pgsql-admin
Hi team,


In a cluster, I have around 15dbs..out of which in 3 dbs creates of temp_files which means I belive work_mem allocation is not sufficient for those dbs. 

Can I resolve this by increasing overall work_mem (set to 25MB now)?

Or by setting work_mem to users consuming those 3 dbs? 

If I may want to increase how to decide on how much to increase?

pgsql-admin by date:

Previous
From: Sai Sadashiva Kundurmutt
Date:
Subject: Re: How to tune SQL performance of function based columns of a view
Next
From: Rajesh Kumar
Date:
Subject: [MASSMAIL]Dynamic views