From: Markus Schaber <schabi@logix-tt.com>
To: Cstdenis <cstdenis@voicio.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How can I make this query faster (resend)
Date: Mon, 22 May 2006 17:30:29 +0200
Message-ID: <4471D915.3010109@logix-tt.com> (raw)
In-Reply-To: <03e001c67b99$8321f010$6401a8c0@chris>
References: <03e001c67b99$8321f010$6401a8c0@chris>
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
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: schabi@logix-tt.com, cstdenis@voicio.com
Subject: Re: How can I make this query faster (resend)
In-Reply-To: <4471D915.3010109@logix-tt.com>
* 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