Re: Howto Increased performace ? - Mailing list pgsql-performance

From Cosimo Streppone
Subject Re: Howto Increased performace ?
Date
Msg-id 41CFF3D2.3090305@team2k.net
Whole thread Raw
In response to Re: Howto Increased performace ?  ("Iain" <iain@mst.co.jp>)
List pgsql-performance
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...

--
Cosimo


pgsql-performance by date:

Previous
From: "Thomas Wegner"
Date:
Subject: Re: Speed in V8.0
Next
From: Karl Vogel
Date:
Subject: Re: Why so much time difference with a same query/plan?