pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: 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: Wed, 23 Feb 2005 13:37:28 -0500
Message-ID: <21021.1109183848@sss.pgh.pa.us> (raw)
In-Reply-To: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com>
References: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com>

"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



view thread (23+ messages)  latest in thread

Message-ID: <21021.1109183848@sss.pgh.pa.us>
Permalink:  ../21021.1109183848@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/21021.1109183848@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, teolupus@gmail.com, adler@pobox.com
  Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout
  In-Reply-To: <21021.1109183848@sss.pgh.pa.us>

* 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