Re: strange

[Greg Smith <greg@xxxxxxxxxxxxxxx>]

Tom Lane wrote:

Szymon Guz <mabewlun@xxxxxxxxx> 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@xxxxxxxxxxxxxxx   www.2ndQuadrant.us