pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Jason Coene <jcoene@gotfrag.com>
Cc: pgsql-performance@postgresql.org
Cc: mendola@bigfoot.com
Cc: tgl@sss.pgh.pa.us
Subject: Re: Caching of Queries
Date: Thu, 23 Sep 2004 17:37:30 -0700
Message-ID: <41536C4A.2010702@commandprompt.com> (raw)
In-Reply-To: <web-6399646@davinci.ethosmedia.com>
References: <web-6399646@davinci.ethosmedia.com>


>>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.
>
>  
>
I would second this. You need to be running a connection pool and 
probably multiple web servers in
front of that. You are talking about a huge amount of connections in 
that amount of time.

Josh Drake



>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>  
>


-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

view thread (72+ messages)  latest in thread

Message-ID: <41536C4A.2010702@commandprompt.com>
Permalink:  ../41536C4A.2010702@commandprompt.com/
Also on:    postgresql.org/message-id/41536C4A.2010702@commandprompt.com

 · 

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: jd@commandprompt.com, josh@agliodbs.com, jcoene@gotfrag.com, mendola@bigfoot.com, tgl@sss.pgh.pa.us
  Subject: Re: Caching of Queries
  In-Reply-To: <41536C4A.2010702@commandprompt.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