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

Re: Which Linux Distribution

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Timothy J Hitchens <tim(at)hitcho(dot)com(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Which Linux Distribution
Date: 2000-11-23 22:49:00
Message-ID: 20001123144900.D18037@fw.wintelcom.net (view raw or flat)
Thread:
Lists: pgsql-admin
* Alfred Perlstein <bright(at)wintelcom(dot)net> [001123 14:33] wrote:
> * Timothy J Hitchens <tim(at)hitcho(dot)com(dot)au> [001123 13:35] wrote:
> > 
> > That is 4 Million Queries per Second which is 14 Billion 400 Million per
> > hour.
> > 
> > This may sound a little big but this is what we will be launching on the 1st
> > December 2000 using postgresql and php.
> 
> What platform is this going to be on?  You will not be able to do
> 4 million queries per second with Postgresql on a PC platform.

You do realize that even a 800Mhz Pentium that the math makes
this practically impossible:

800Mhz ==   8,000,000 cycles per second
divided by  4,000,000 queries per second
                  = 2 cycles per query

Those two cycles are spent even before the server gets to
parse the query.

What are you trying to do here?

-- 
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."

In response to

Responses

pgsql-admin by date

Next:From: Paul McGarryDate: 2000-11-24 02:57:11
Subject: RE: Load of 4 Million Queries Read and or Write Per Second
Previous:From: Alfred PerlsteinDate: 2000-11-23 22:23:22
Subject: Re: Which Linux Distribution

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