Skip site navigation (1) Skip section navigation (2)

Re: Howto Increased performace ?

From: Cosimo Streppone <cstreppone(at)team2k(dot)net>
To: Iain <iain(at)mst(dot)co(dot)jp>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Howto Increased performace ?
Date: 2004-12-27 11:36:50
Message-ID: 41CFF3D2.3090305@team2k.net (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-performance by date

Next:From: JeffDate: 2004-12-27 13:46:28
Subject: Re: Some Performance Advice Needed
Previous:From: IainDate: 2004-12-27 09:34:45
Subject: Re: Howto Increased performace ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group