Iain wrote:

sort_mem 4096 (=400MB RAM for 100 connections)

If I understand correctly, memory usage related to `sort_mem' is per connection *and* per sort. If every client runs a query with 3 sorts in its plan, you are going to need (in theory) 100 connections * 4Mb * 3 sorts, which is 1.2 Gb.

Please correct me if I'm wrong...


---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Reply via email to