X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 466813F9189 for ; Mon, 27 Dec 2004 11:37:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66144-05 for ; Mon, 27 Dec 2004 11:37:10 +0000 (GMT) Received: from ebrsrv01.ebravo.it (host166-198.pool21757.interbusiness.it [217.57.198.166]) by svr1.postgresql.org (Postfix) with ESMTP id E995A3F9181 for ; Mon, 27 Dec 2004 11:37:07 +0000 (GMT) Received: from [192.168.11.103] ([192.168.11.103]) (authenticated) by ebrsrv01.ebravo.it (8.11.6/8.12.5) with ESMTP id iBRBatw01240; Mon, 27 Dec 2004 12:36:55 +0100 Message-ID: <41CFF3D2.3090305@team2k.net> Date: Mon, 27 Dec 2004 12:36:50 +0100 From: Cosimo Streppone Organization: Team2k User-Agent: Mozilla Thunderbird 0.9 (X11/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Iain Cc: Postgresql Performance Subject: Re: Howto Increased performace ? References: <2452.192.168.2.6.1103621509.squirrel@192.168.2.6> <00cb01c4ebb3$94aebf10$7201a8c0@mst1x5r347kymb> <45410.192.168.2.17.1104139293.squirrel@192.168.2.17> <003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb> In-Reply-To: <003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb> Content-Type: text/plain; charset=windows-874; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/311 X-Sequence-Number: 9686 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