Skip site navigation (1) Skip section navigation (2)

Re: Caching of Queries

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>,Jason Coene <jcoene(at)gotfrag(dot)com>, pgsql-performance(at)postgresql(dot)org,tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Caching of Queries
Date: 2004-09-25 16:58:09
Message-ID: 4155A3A1.7050905@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Joshua D. Drake wrote:
|
|>>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.

Not to mention that a proxy squid mounted in reverse proxy mode will
help a lot.


Regards
Gaetano Mendola






-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBVaOg7UpzwH2SGd4RAnW4AJ9TYV0oSjYcv8Oxt4Ot/T/nJikoRgCg1Egx
r4KKm14ziu/KWFb3SnTK/U8=
=xgmw
-----END PGP SIGNATURE-----


In response to

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2004-09-25 17:25:08
Subject: Re: Caching of Queries (now with pgpool)
Previous:From: Rod TaylorDate: 2004-09-25 00:57:15
Subject: Getting rid of nested loop

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group