Hello there!
I would like to propose to developers a new feature to replace the private management of the work mem with a management through shared memory: allocated at the start of PostgreSQL this area should be shared to all worker processes as for example Oracle Database PGA do.
This would allow an optimal use of this memory area by limiting only its global maximum limit and not a configuration/allocation at the process level.
What do you think about my proposal?
Cheers,
Marco