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-24 07:14:03
Message-ID: 20001123231402.A8051@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

* Alfred Perlstein <bright(at)wintelcom(dot)net> [001123 15:04] wrote:
> * 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

er, turkey makes me a bit groggy, that should have been:

800,000,000
4,000,000

still about 200 cycles per query. I don't see how that's
possible.

--
-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

Browse pgsql-admin by date

  From Date Subject
Next Message Avi Schwartz 2000-11-24 17:33:48 Trojan Alert
Previous Message Paul McGarry 2000-11-24 02:57:11 RE: Load of 4 Million Queries Read and or Write Per Second