From: Greg Smith <gsmith@gregsmith.com>
To: Carlos Moreno <morenopg@mochima.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: "Mysterious" issues with newly installed 8.3
Date: Mon, 13 Oct 2008 17:37:53 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0810131721500.26116@westnet.com> (raw)
In-Reply-To: <48F3615B.4050705@mochima.com>
References: <48EE98FE.60100@mochima.com>
<a1ec7d000810091734k60cee7d7qb95470936ad461c1@mail.gmail.com>
<Pine.GSO.4.64.0810100345010.26609@westnet.com>
<48F3615B.4050705@mochima.com>
On Mon, 13 Oct 2008, Carlos Moreno wrote:
>> Another really handy way to gauge memory speed on Linux, if there are
>> similar kernels installed on each system like your case, is to use
>> "hdparm -T".
>
> Great tip! I was familiar with the -T switch, but was not clear on the
> notion that the figure tells you that much about the overall memory
> performance!
I wouldn't go so far as to say it tells you *much* about it, but it does
give a fairly useful comparison figure if the kernels are basically the
same and can help spot gross errors. I used it a bunch when I was
tinkering with DDR speeds and such earlier this year, it correlated fairly
well with other memory bandwidth measurements within the same processor
family (so far my tests suggestion results are much higher per clock on
Intel CPUs). Certainly of no use for comparison if one system has a
32-bit kernel and the other 64, and results will vary depending on general
kernel configuration (I get very different results from seemingly similar
RedHat and Ubuntu kernels on the same system for example).
It sounds like your CPU and memory setup are all fine, which leaves your
mystery open. Please let us know if you find anything interesting out,
normally an 8.3 upgrade would run faster so your situation is a bit
curious. The only other benchmark I'd suggest just as a sanity check is
bonnie++, that's a bit more thorough than what hdparm -t reports.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsmith@gregsmith.com, morenopg@mochima.com
Subject: Re: "Mysterious" issues with newly installed 8.3
In-Reply-To: <Pine.GSO.4.64.0810131721500.26116@westnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox