Decibel! wrote:
>
> Yes, this problem goes way beyond OOM. Just try and configure
> work_memory aggressively on a server that might see 50 database
> connections, and do it in such a way that you won't swap. Good luck.
That sounds like an even broader and more difficult problem
than managing memory.
If you have 50 connections that all want to perform large sorts,
what do you want to have happen?
a) they each do their sorts in parallel with small amounts
of memory for each; probably all spilling to disk?
b) they each get a big chunk of memory but some have to
wait for each other?
c) something else?
Seems (a)'s already possible today with setting small work_mem.
Seems (b)'s already possible today with a larger work_mem and
pg_pool.
Stepping back from the technical details, what do you think
should happen. (though perhaps it should be taken to a different
thread)
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
