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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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