Re: more than 1000 connections

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

On Wed, Aug 6, 2008 at 1:38 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Wed, Aug 6, 2008 at 11:29 AM, Jorge Medina <jorge(at)bsdchile(dot)cl> wrote:
>> On Wed, Aug 6, 2008 at 12:47 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>>> 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?
>>>
>> affect directly the performance
>
> I'm trying to help you here, but that answer helps no one.
>
I know, sorry but the logs don't show anything when many people try
login from the webmail begin to grow connections to postgresql and the
all system turn too slow.

--
Jorge Andrés Medina Oliva.
Evolve or die!

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2008-08-06 21:39:45 Re: more than 1000 connections
Previous Message CHUNRIMACHUNRIMA 2008-08-06 18:52:34 How to creat tables using record ID in for loop