From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org> |
Subject: | [Fwd: Re: CPU types and queries...] |
Date: | 2002-05-29 23:29:54 |
Message-ID: | 1022714995.17105.14.camel@rebel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
And, of course, you VACUUM ANALYZE each database nightly...
-----Forwarded Message-----
> From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
> To: James Kelty <jamesk(at)ashlandagency(dot)com>
> Subject: Re: [NOVICE] CPU types and queries...
> Date: 29 May 2002 18:27:04 -0500
>
> On Wed, 2002-05-29 at 16:00, James Kelty wrote:
> >
> >
> > Hello,
> >
> > A question was recently brought up at my place of business about CPU
> > types, and Postgres.
> >
> > We have Two systems, both running Red Hat 7.2, both with 4Gig's of PC133
> > memory.
> >
> > The first system has TWO 933Mhz Intel PIII (Coppermine) procs, and a
> > certain query returns VERY fast, around 2 seconds.
> >
> > The second system has TWO 700Mhx Intel PIII Xeon (Cascades) procs, but
> > the same query from the same code from the same web server takes approx.
> > 10-12 seconds.
> >
> > Is there REALLY that much difference between the two proc types? Will
> > 233Mhz actually make THAT much of a difference?
> >
> > What about the big Xeon cache? 1Mb vs. the Coppermine 256k cache?
>
> This is presuming that the databases are the same size, and reside
> on exactly the same kind of disks, controllers, shared_buffers size,
> indexes, number of rows, etc, right?
--
+---------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://ronandheather.dhs.org:81 |
| |
| "I have created a government of whirled peas..." |
| Maharishi Mahesh Yogi, 12-May-2002, |
! CNN, Larry King Live |
+---------------------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | danix | 2002-05-30 03:58:09 | ideal filesystem layout |
Previous Message | Josh Berkus | 2002-05-29 23:12:17 | Re: Database Ownership |