Re: [PERFORM] Performance of Seq Scan from buffer cache

2012-08-23 Thread Merlin Moncure
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

Re: [PERFORM] Performance of Seq Scan from buffer cache

2012-08-21 Thread Matt Daw
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