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

Re: How can I make this query faster (resend)

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Cstdenis <cstdenis(at)voicio(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How can I make this query faster (resend)
Date: 2006-05-22 15:30:29
Message-ID: 4471D915.3010109@logix-tt.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Meetesh KariaDate: 2006-05-22 17:20:09
Subject: Query hanging/not finishing inconsistently
Previous:From: Jim C. NasbyDate: 2006-05-22 15:30:08
Subject: Re: Performs WAY better with enable_seqscan = off

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