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!
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 |