Re: [SQL] more than 1000 connections

2008-08-06 Thread Craig Ringer
Jorge Medina wrote: > I have many trouble's with server, because my webmail(roundcube) works > with the db and the machine only have 2G of RAM 2GB of RAM can go a long way. It looks like this webmail app is sensible enough to use IMAP for mail store access, so you don't have to worry about message

Re: [SQL] more than 1000 connections

2008-08-06 Thread Scott Marlowe
On Wed, Aug 6, 2008 at 1:34 PM, Jorge Medina <[EMAIL PROTECTED]> wrote: > On Wed, Aug 6, 2008 at 1:38 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: >> On Wed, Aug 6, 2008 at 11:29 AM, Jorge Medina <[EMAIL PROTECTED]> wrote: >>> On Wed, Aug 6, 2008 at 12:47 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote

Re: [SQL] more than 1000 connections

2008-08-06 Thread Jorge Medina
On Wed, Aug 6, 2008 at 1:38 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Wed, Aug 6, 2008 at 11:29 AM, Jorge Medina <[EMAIL PROTECTED]> wrote: >> On Wed, Aug 6, 2008 at 12:47 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: >>> On Wed, Aug 6, 2008 at 10:42 AM, Jorge Medina <[EMAIL PROTECTED]> wrot

Re: [SQL] more than 1000 connections

2008-08-06 Thread Scott Marlowe
On Wed, Aug 6, 2008 at 10:42 AM, Jorge Medina <[EMAIL PROTECTED]> 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 > prob

Re: [SQL] more than 1000 connections

2008-08-06 Thread Jorge Medina
On Wed, Aug 6, 2008 at 11:54 AM, Mark Roberts <[EMAIL PROTECTED]> wrote: > > On Wed, 2008-08-06 at 08:06 +0800, Craig Ringer wrote: >> Out of interest - why 1000 connections? >> >> Do you really expect to have 1000 jobs concurrently active and doing >> work? If you don't, then you'll be wasting res

Re: [SQL] more than 1000 connections

2008-08-06 Thread Mark Roberts
On Wed, 2008-08-06 at 08:06 +0800, Craig Ringer wrote: > Out of interest - why 1000 connections? > > Do you really expect to have 1000 jobs concurrently active and doing > work? If you don't, then you'll be wasting resources and slowing > things > down for no reason. There is a connection overhea

Re: [SQL] more than 1000 connections

2008-08-05 Thread Craig Ringer
Jorge Medina wrote: > hi guys > > I know this list it's about SQL, but if somebody have a pgsql engine > with 1000 or more concurrent connections please show me the > postgresql.conf or if the pgpool work as a solution to this problem. Out of interest - why 1000 connections? Do you really expect

Re: [SQL] more than 1000 connections

2008-08-05 Thread Richard Broersma
On Tue, Aug 5, 2008 at 12:11 PM, Jorge Medina <[EMAIL PROTECTED]> wrote: > ok, so I think if can not increment the max_connections to 1000 > because my main memory it's 2G some test with max connections allowed > ? Sorry I don't understand your question. Also, don't forget to reply-all so that

Re: [SQL] more than 1000 connections

2008-08-05 Thread Richard Broersma
On Tue, Aug 5, 2008 at 8:14 AM, Jorge Medina <[EMAIL PROTECTED]> wrote: > I know this list it's about SQL, but if somebody have a pgsql engine > with 1000 or more concurrent connections please show me the > postgresql.conf or if the pgpool work as a solution to this problem. The PG performance li

[SQL] more than 1000 connections

2008-08-05 Thread Jorge Medina
hi guys I know this list it's about SQL, but if somebody have a pgsql engine with 1000 or more concurrent connections please show me the postgresql.conf or if the pgpool work as a solution to this problem. thanks. -- Jorge Andrés Medina Oliva. Evolve or die! -- Sent via pgsql-sql mailing list