> 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...
In response to
pgsql-performance by date
|Next:||From: Jeff||Date: 2004-12-27 13:46:28|
|Subject: Re: Some Performance Advice Needed|
|Previous:||From: Iain||Date: 2004-12-27 09:34:45|
|Subject: Re: Howto Increased performace ?|