I would second this. You need to be running a connection pool and probably multiple web servers inSorry, 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. 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 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL |
- Re: [PERFORM] Caching of Queries Jason Coene
- Re: [PERFORM] Caching of Queries Tom Lane
- Re: [PERFORM] Caching of Queri... Jason Coene
- Re: [PERFORM] Caching of Q... Tom Lane
- Re: [PERFORM] Caching ... Josh Berkus
- Re: [PERFORM] Cac... Tom Lane
- Re: [PERFORM] Caching of Q... Gaetano Mendola
- Re: [PERFORM] Caching ... Jason Coene
- Re: [PERFORM] Cac... Jason Coene
- Re: [PERFORM] Cac... Josh Berkus
- Re: [PERFORM] Cac... Joshua D. Drake
- Re: [PERFORM] Cac... Gaetano Mendola
- Re: [PERFORM] Cac... Jason Coene
- Re: [PERFORM] Cac... Michael Adler
- Re: [PERFORM] Cac... Gaetano Mendola
- Re: [PERFORM] Caching of Queries Gaetano Mendola
- Re: [PERFORM] Caching of Queri... Pierre-Frédéric Caillaud
- Re: [PERFORM] Caching of Queries Greg Stark
- Re: [PERFORM] Caching of Queries Matt Clark
- Re: [PERFORM] Caching of Queries Markus Schaber
- Re: [PERFORM] Caching of Queries Jim C. Nasby