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: (view raw, whole thread or download thread mbox)
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:

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.

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

Fight against software patents in EU!

In response to


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-2017 The PostgreSQL Global Development Group