Skip site navigation (1) Skip section navigation (2)

Re: Fun little performance IMPROVEMENT...

From: grant(at)amadensor(dot)com
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fun little performance IMPROVEMENT...
Date: 2011-01-21 20:23:15
Message-ID: 6db0dcf63cdcbdce27f8f941de3e623d.squirrel@grant.boldlygoingnowhere.org (view raw or flat)
Thread:
Lists: pgsql-performance
> grant(at)amadensor(dot)com writes:
>> Here is the fun part.   When running 8 threads spinning calculating
>> square
>> roots (using the stress package), the full scan returned consistently
>> 60%
>> faster than the machine with no load.
>
> Possibly the synchronized-seqscans logic kicking in, resulting in this
> guy not having to do all his own I/Os.  It would be difficult to make
> any trustworthy conclusions about performance in such cases from a view
> of only one process's results --- you'd need to look at the aggregate
> behavior to understand what's happening.
>
> 			regards, tom lane
>
My though was that either:

1)  It was preventing some other I/O or memory intensive process from
happening, opening the resources up.
2)  It was keeping the machine busy from the hypervisor's point of view,
preventing it from waiting for a slot on the host machine.
3)  The square roots happen quickly, resulting in more yields, and
therefore more time slices for my process than if the system was in its
idle loop.

Any way you look at it, it is fun and interesting that a load can make
something unrelated happen more quickly.   I will continue to try to find
out why it is the case.



In response to

Responses

pgsql-performance by date

Next:From: Scott CareyDate: 2011-01-21 21:10:50
Subject: Re: Fun little performance IMPROVEMENT...
Previous:From: Tom LaneDate: 2011-01-21 20:22:24
Subject: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group