pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Cosimo Streppone <cstreppone@team2k.net>
To: Iain <iain@mst.co.jp>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Howto Increased performace ?
Date: Mon, 27 Dec 2004 12:36:50 +0100
Message-ID: <41CFF3D2.3090305@team2k.net> (raw)
In-Reply-To: <003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb>
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>

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




view thread (9+ messages)  latest in thread

Message-ID: <41CFF3D2.3090305@team2k.net>
Permalink:  ../41CFF3D2.3090305@team2k.net/
Also on:    postgresql.org/message-id/41CFF3D2.3090305@team2k.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: cstreppone@team2k.net, iain@mst.co.jp
  Subject: Re: Howto Increased performace ?
  In-Reply-To: <41CFF3D2.3090305@team2k.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox