Re: more than 1000 connections - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: more than 1000 connections
Date
Msg-id dcc563d10808060947r6bd55971x7efd7b0b8b5e1935@mail.gmail.com
Whole thread Raw
In response to Re: more than 1000 connections  ("Jorge Medina" <jorge@bsdchile.cl>)
List pgsql-sql
On Wed, Aug 6, 2008 at 10:42 AM, Jorge Medina <jorge@bsdchile.cl> wrote:
>>
> I have many trouble's with server, because my webmail(roundcube) works
> with the db and the machine only have 2G of RAM but collapse with 60
> concurrent connections, I try with persistent connections and the same
> problem, I need configure a pool of connection or something.
> my config
> max_connections = 100;
> shared_buffer = 32MB
> increase to 460 connections and 128MB of shared buffers but it's the same

What, exactly, are the symptoms of a collapse?  What do the logs
(pgsql, system, your application) have to say?


pgsql-sql by date:

Previous
From: "Jorge Medina"
Date:
Subject: Re: more than 1000 connections
Next
From: CHUNRIMACHUNRIMA
Date:
Subject: How to creat tables using record ID in for loop