Re: [PERFORM] EXPLAIN ANALYZE on 8.2

"Martijn van Oosterhout" <kleptog@svana.org> writes:

> BTW, doing gettimeofday() without kernel entry is not really possible.

That's too strong a conclusion. Doing gettimeofday() without some help from
the kernel isn't possible but it isn't necessary to enter the kernel for each
call.

There are various attempts at providing better timing infrastructure at low
overhead but I'm not sure what's out there currently. I expect to do this what
we'll have to do is invent a pg_* abstraction that has various implementations
on different architectures. On Solaris it can use DTrace internally, on Linux
it might have something else (or more likely several different options
depending on the age and config options of the kernel). 

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com