Re: more than 1000 connections
От | Jorge Medina |
---|---|
Тема | Re: more than 1000 connections |
Дата | |
Msg-id | 28d0e6b80808061234h450e6f58m12162b3a31bdca32@mail.gmail.com обсуждение исходный текст |
Ответ на | more than 1000 connections ("Jorge Medina" <jorge@bsdchile.cl>) |
Ответы |
Re: more than 1000 connections
|
Список | 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 по дате отправления: