-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
| Gaetano Mendola <[EMAIL PROTECTED]> writes:
|
|>I did last week an Ariadne+Postgresql valutation for the company where I work
|>and I learned that
|>with 250 MB you can open up to 80 concurrent query
|>with 500 MB you can open up to 1
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> I did last week an Ariadne+Postgresql valutation for the company where I work
> and I learned that
> with 250 MB you can open up to 80 concurrent query
> with 500 MB you can open up to 120 concurrent query
> from now on for each 250MB you can have ~40
Tom Lane wrote:
Michal Taborsky <[EMAIL PROTECTED]> writes:
Peter Eisentraut wrote:
Is there any practical limit on the number of parallel connections that a
PostgreSQL server can service? We're in the process of setting up a system
that will require up to 1 connections open in parallel. Th
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Peter Eisentraut) would
write:
> Is there any practical limit on the number of parallel connections that a
> PostgreSQL server can service? We're in the process of setting up a system
> that will require up to 1 connections open in
[snip]
> requests, it only saves connection start effort. (You could make the
> connection pool server queue the requests, but that is not the point of this
> exercise.) I didn't quite consider the RAM question, but the machine is
[snip]
Well, I would disagree here. If the connections are not
Really, this seems like it would be a pretty strong case for a
replicated database. assuming not all 1 clients will need to be
doing modifications. Or if they do, that they could open up a seperate,
temporary connection with the master db.
On Aug 16, 2004, at 7:37 AM, Peter Eisentraut w
Michal Taborsky <[EMAIL PROTECTED]> writes:
> Peter Eisentraut wrote:
>> Is there any practical limit on the number of parallel connections that a
>> PostgreSQL server can service? We're in the process of setting up a system
>> that will require up to 1 connections open in parallel. The que
Am Montag, 16. August 2004 16:20 schrieb Csaba Nagy:
> Peter is definitely not a newby on this list, so i'm sure he already
> thought about some kind of pooling if applicable... but then I'm
> dead-curious what kind of application could possibly rule out connection
> pooling even if it means so man
Hi guys,
Peter is definitely not a newby on this list, so i'm sure he already
thought about some kind of pooling if applicable... but then I'm
dead-curious what kind of application could possibly rule out connection
pooling even if it means so many open connections ? Please give us some
light Pete