On Tue, Aug 21, 2012 at 6:59 PM, Matt Daw wrote:
> Ugh, never mind. I ran ltrace and it's spending 99% of its time in
> gettimeofday.
yeah -- this is a fairly common report. some systems (windows) have a
less accurate but much faster gettimeofday().
merlin
--
Sent via pgsql-performance maili
Ugh, never mind. I ran ltrace and it's spending 99% of its time in
gettimeofday.
select count(*) from notes;
count
-
1926207
(1 row)
Time: 213.950 ms
explain analyze select count(*) from notes;
QUERY PLAN
Howdy. I'm curious what besides raw hardware speed determines the performance
of a Seq Scan that comes entirely out of shared buffers… I ran the following on
the client's server I'm profiling, which is otherwise idle:
EXPLAIN (ANALYZE ON, BUFFERS ON) SELECT * FROM notes;
Seq Scan on notes (cos
