Work_mem

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

To: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Work_mem
From: Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx>
Date: Mon, 8 Apr 2024 12:20:06 +0530

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?

Follow-Ups:
- Re: Work_mem
  - From: Jeff Janes
- Re: Work_mem
  - From: Laurenz Albe

Prev by Date: Re: How to tune SQL performance of function based columns of a view
Next by Date: Dynamic views
Previous by thread: Re: Global memory or local memory? (was Re: work_mem)
Next by thread: Re: Work_mem
Index(es):
- Date
- Thread

[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