X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 2FAD79F9A8D
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 22 May 2006 12:30:25 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 53873-09
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 22 May 2006 12:30:13 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186])
	by postgresql.org (Postfix) with ESMTP id 649019F946D
	for <pgsql-performance@postgresql.org>;
	Mon, 22 May 2006 12:30:13 -0300 (ADT)
Received: from kingfisher.intern.logix-tt.com (Tb043.t.pppool.de
	[89.55.176.67])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.logix-tt.com (Postfix) with ESMTP id 52666656C0;
	Mon, 22 May 2006 17:31:30 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 9AA89185B60B8;
	Mon, 22 May 2006 17:30:29 +0200 (CEST)
Message-ID: <4471D915.3010109@logix-tt.com>
Date: Mon, 22 May 2006 17:30:29 +0200
From: Markus Schaber <schabi@logix-tt.com>
Organization: Logical Tracking and Tracing International AG, Switzerland
User-Agent: Debian Thunderbird 1.0.7 (X11/20051017)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Cstdenis <cstdenis@voicio.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How can I make this query faster (resend)
References: <03e001c67b99$8321f010$6401a8c0@chris>
In-Reply-To: <03e001c67b99$8321f010$6401a8c0@chris>
X-Enigmail-Version: 0.93.0.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/419
X-Sequence-Number: 19206

Hi, Cstendis,

Cstdenis wrote:

> Server is a dual xeon with a gig of ram dedicated mostly to postgresql.
> Here is the changed lines in my postgresql.conf: http://pastebin.ca/57222

3M is really low for a production server.

Try using pg_pool and limiting it to about 30 or so backend connections,
and then give them at least 30 megs of RAM each.

This should also cut down the connection creation overhead.

HTH,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org