On 03/17/2011 11:13 AM, Jeff wrote:
three boxes:
A: Intel(R) Xeon(R) CPU E5345 @ 2.33GHz (Runs query
fastest)
4MB cache
B: Quad-Core AMD Opteron(tm) Processor 2352 (2.1GHZ) (Main
production box, currently, middle speed)
512k cache
C: Quad-Core AMD
On Mar 17, 2011, at 9:39 PM, Scott Marlowe wrote:
My experience puts the 23xx series opterons in a same general
neighborhood as the E5300 and a little behind the E5400 series Xeons.
OTOH, the newer Magny Cours Opterons stomp both of those into the
ground.
Do any of those machines have
hey folks,
Running into some odd performance issues between a few of our db
boxes. While trying to speed up a query I ran it on another box and
it was twice as fast. The plans are identical and various portions of
the query run in the same amount of time - it all boils down to most
of
On Thu, Mar 17, 2011 at 10:13 AM, Jeff thres...@torgo.978.org wrote:
hey folks,
Running into some odd performance issues between a few of our db boxes.
We've noticed similar results both in OLTP and data warehousing conditions here.
Opteron machines just seem to lag behind *especially* in
On Thu, Mar 17, 2011 at 1:42 PM, J Sisson sisso...@gmail.com wrote:
On Thu, Mar 17, 2011 at 10:13 AM, Jeff thres...@torgo.978.org wrote:
hey folks,
Running into some odd performance issues between a few of our db boxes.
We've noticed similar results both in OLTP and data warehousing
On 3/17/11 9:42 AM, J Sisson wrote:
On Thu, Mar 17, 2011 at 10:13 AM, Jeffthres...@torgo.978.org wrote:
hey folks,
Running into some odd performance issues between a few of our db boxes.
We've noticed similar results both in OLTP and data warehousing conditions here.
Opteron machines just
-Original Message-
From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-
ow...@postgresql.org] On Behalf Of Jeff
Sent: Thursday, March 17, 2011 9:14 AM
To: pgsql-performance@postgresql.org
Cc: Brian Ristuccia
Subject: [PERFORM] Xeon twice the performance
On Thu, Mar 17, 2011 at 9:13 AM, Jeff thres...@torgo.978.org wrote:
hey folks,
Running into some odd performance issues between a few of our db boxes.
While trying to speed up a query I ran it on another box and it was twice
as fast. The plans are identical and various portions of the query