pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <decibel@decibel.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruno Almeida do Lago <teolupus@gmail.com>
Cc: Michael Adler <adler@pobox.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout
Date: Fri, 25 Feb 2005 10:20:05 -0600
Message-ID: <20050225162005.GK84483@decibel.org> (raw)
In-Reply-To: <21021.1109183848@sss.pgh.pa.us>
References: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com>
	<21021.1109183848@sss.pgh.pa.us>

On Wed, Feb 23, 2005 at 01:37:28PM -0500, Tom Lane wrote:
> "Bruno Almeida do Lago" <teolupus@gmail.com> writes:
> > Is there a real limit for max_connections? Here we've an Oracle server with
> > up to 1200 simultaneous conections over it!
> 
> [ shrug... ] If your machine has the beef to run 1200 simultaneous
> queries, you can set max_connections to 1200.
> 
> The point of what you were quoting is that if you want to service
> 1200 concurrent users but you only expect maybe 100 simultaneously
> active queries from them (and you have a database box that can only
> service that many) then you want to put a connection pooler in
> front of 100 backends, not try to start a backend for every user.
> 
> Oracle may handle this sort of thing differently, I dunno.
> 
> 			regards, tom lane

Oracle has some form of built-in connection pooling. I don't remember
the exact details of it off the top of my head, but I think it was a
'wedge' that clients would connect to as if it was the database, and the
wedge would then find an available database process to use.
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"



view thread (23+ messages)  latest in thread

Message-ID: <20050225162005.GK84483@decibel.org>
Permalink:  ../20050225162005.GK84483@decibel.org/
Also on:    postgresql.org/message-id/20050225162005.GK84483@decibel.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: decibel@decibel.org, tgl@sss.pgh.pa.us, teolupus@gmail.com, adler@pobox.com
  Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout
  In-Reply-To: <20050225162005.GK84483@decibel.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox