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

From Jorge Medina
Subject Re: more than 1000 connections
Date
Msg-id 28d0e6b80808061234h450e6f58m12162b3a31bdca32@mail.gmail.com
Whole thread Raw
In response to more than 1000 connections  ("Jorge Medina" <jorge@bsdchile.cl>)
Responses Re: more than 1000 connections
List pgsql-sql
On Wed, Aug 6, 2008 at 1:38 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Wed, Aug 6, 2008 at 11:29 AM, Jorge Medina <jorge@bsdchile.cl> wrote:
>> On Wed, Aug 6, 2008 at 12:47 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>>> 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?
>>>
>> 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!


pgsql-sql by date:

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