From: Josh Berkus <josh@agliodbs.com>
To: Jason Coene <jcoene@gotfrag.com>
To: pgsql-performance@postgresql.org
Cc: mendola@bigfoot.com
Cc: tgl@sss.pgh.pa.us
Cc: josh@agliodbs.com
Subject: Re: Caching of Queries
Date: Thu, 23 Sep 2004 17:05:58 -0700
Message-ID: <web-6399646@davinci.ethosmedia.com> (raw)
In-Reply-To: <200409231907.i8NJ7rv2004899@ms-smtp-03.nyroc.rr.com>
Jason,
> Sorry, I meant 30,000 with 300 connections - not 3,000. The 300
> connections
> / second is realistic, if not underestimated. As is the nature of
> our site
> (realtime information about online gaming), there's a huge fan base
> and as a
> big upset happens, we'll do 50,000 page views in a span of 3-5
> minutes.
First, your posts show no evidences of the CS storm bug.
Second, 300 *new* connections a second is a lot. Each new connection
requires a significant amount of both database and OS overhead. This
is why all the other web developers use a connection pool.
In fact, I wouldn't be surprised if your lockups are on the OS level,
even; I don't recall that you cited what OS you're using, but I can
imagine locking up Linux 2.4 trying to spawn 300 new processes a
second.
--Josh
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: josh@agliodbs.com, jcoene@gotfrag.com, mendola@bigfoot.com, tgl@sss.pgh.pa.us
Subject: Re: Caching of Queries
In-Reply-To: <web-6399646@davinci.ethosmedia.com>
* 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