X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 84BD953526 for ; Thu, 12 May 2005 13:22:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73276-09 for ; Thu, 12 May 2005 16:21:56 +0000 (GMT) Received: from server07.icaen.uiowa.edu (server07.icaen.uiowa.edu [128.255.17.47]) by svr1.postgresql.org (Postfix) with ESMTP id 3A48E53429 for ; Thu, 12 May 2005 13:21:55 -0300 (ADT) Received: from server11.icaen.uiowa.edu (server11.icaen.uiowa.edu [128.255.17.51]) by server07.icaen.uiowa.edu (8.13.3/8.12.9) with ESMTP id j4CGK1cB019009; (envelope-from ) Thu, 12 May 2005 11:20:01 -0500 (CDT) Received: from [192.168.1.11] (12-215-118-172.client.mchsi.com [12.215.118.172]) (authenticated user=jfmeinel) by server11.icaen.uiowa.edu (8.13.2/smtp-serv-1.7) with ESMTP id j4CGJuiE010054 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256); (envelope-from ) Thu, 12 May 2005 11:19:57 -0500 (CDT) Message-ID: <4283822C.5010305@arbash-meinel.com> Date: Thu, 12 May 2005 11:19:56 -0500 From: John A Meinel User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alex Turner Cc: Alex Stapleton , PFC , josh@agliodbs.com, David Roussel , pgsql-performance@postgresql.org Subject: Re: Partitioning / Clustering References: <5F94B6EB-3925-4CD3-A67F-4310890B438A@advfn.com> <200505111013.52067.josh@agliodbs.com> <1115798277.29223.233869472@webmail.messagingengine.com> <33c6269f050512070842df1af3@mail.gmail.com> <360CDE65-3FAF-428A-BA25-6F6ECCAA5689@advfn.com> <33c6269f0505120905192dc723@mail.gmail.com> In-Reply-To: <33c6269f0505120905192dc723@mail.gmail.com> X-Enigmail-Version: 0.89.6.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigE5BADADFA3137300EDC25CE6" X-Virus-Scanned: ClamAV version 0.83, clamav-milter version 0.83 on clamav.icaen.uiowa.edu X-Virus-Scanned: ClamAV version 0.83, clamav-milter version 0.83 on clamav.icaen.uiowa.edu X-Virus-Status: Clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/241 X-Sequence-Number: 12405 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigE5BADADFA3137300EDC25CE6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Alex Turner wrote: > Ok - my common sense alarm is going off here... > > There are only 6.446 billion people worldwide. 100 Billion page views > would require every person in the world to view 18 pages of yahoo > every day. Not very likely. > > http://www.internetworldstats.com/stats.htm > suggests that there are around 1 billion people actualy on the internet. > > That means each and every person on the internet has to view 100 pages > per day of yahoo. > > pretty unlikely IMHO. I for one don't even use Yahoo ;) > > 100 million page views per day suggests that 1 in 100 people on the > internet each viewed 10 pages of a site. Thats a pretty high > percentage if you ask me. In general I think your point is valid. Just remember that it probably also matters how you count page views. Because technically images are a separate page (and this thread did discuss serving up images). So if there are 20 graphics on a specific page, that is 20 server hits just for that one page. I could easily see an image heavy site getting 100 hits / page. Which starts meaning that if 1M users hit 10 pages, then you get 1M*10*100 = 1G. I still think 100G views on a single website is a lot, but 100M is certainly possible. John =:-> --------------enigE5BADADFA3137300EDC25CE6 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFCg4IsJdeBCYSNAAMRAmaRAJ4m2Dzt0AO8CvntaWhshLQs0NNN1QCfZ+rq ZRho2V4L3CgwxJtAgcUsAKg= =V13o -----END PGP SIGNATURE----- --------------enigE5BADADFA3137300EDC25CE6--