From: grant@amadensor.com
To: pgsql-performance@postgresql.org
Subject: Re: Fun little performance IMPROVEMENT...
Date: Fri, 21 Jan 2011 13:18:55 -0700 (MST)
Message-ID: <e4f4c267cceafee13c7ae455c7bf1ffc.squirrel@grant.boldlygoingnowhere.org> (raw)
In-Reply-To: <4D39D07B.1070802@squeakycode.net>
References: <fb95011e666ffd6528d0b57542d7097f.squirrel@grant.boldlygoingnowhere.org>
<4D39D07B.1070802@squeakycode.net>
>
> Odd. Did'ja by chance run the select more than once... maybe three or
> four times, and always get the same (or close) results?
>
> Is the stress package running niced?
>
The stress package is not running niced. I ran it initially 5 times each.
It was very consistent. Initially, I just ran everything to files.
Later when I looked over it, I was confused, so tried it again, several
times on each, with very little deviation, and the process with the CPU
stressed always being faster.
The only deviation, which is understandable, was that the first run of
anything after memory stress (using 7G of the available 8G). was slow as
it swapped back in, so I did a swapoff/swapon to clear up swap, and still
got the same results.
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: grant@amadensor.com
Subject: Re: Fun little performance IMPROVEMENT...
In-Reply-To: <e4f4c267cceafee13c7ae455c7bf1ffc.squirrel@grant.boldlygoingnowhere.org>
* 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