Re: more than 1000 connections

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Jorge Medina" <jorge(at)bsdchile(dot)cl>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: more than 1000 connections
Date: 2008-08-06 16:47:19
Message-ID: dcc563d10808060947r6bd55971x7efd7b0b8b5e1935@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Aug 6, 2008 at 10:42 AM, Jorge Medina <jorge(at)bsdchile(dot)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?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message CHUNRIMACHUNRIMA 2008-08-06 18:52:34 How to creat tables using record ID in for loop
Previous Message Jorge Medina 2008-08-06 16:42:54 Re: more than 1000 connections