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
