Re: strange

Tom Lane wrote:

Szymon Guz <mabewlun@gmail.com> writes: 

I've got a simple query. When I use explain analyze it lasts 7 times slower.
Why?   

You've got a machine where gettimeofday() is really slow.  This is
common on cheap PC hardware :-( 

I'd be curious to know more about the hardware and operating system Szymon is using if you suspect this is the case.  I keep hearing about systems where this is slow, but despite claims that they're common I've never actually seen one.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us