Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance of Seq Scan from buffer cache - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Performance of Seq Scan from buffer cache
Date
Msg-id CAHyXU0zzdWBpjy8GkjAQjCOAR4UD2KH+ztJGLqSKV4Fn+PLR_w@mail.gmail.com
Whole thread Raw
In response to Re: Performance of Seq Scan from buffer cache  (Matt Daw <matt@shotgunsoftware.com>)
List pgsql-performance
Tree view 
On Tue, Aug 21, 2012 at 6:59 PM, Matt Daw <matt@shotgunsoftware.com> 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

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Increasing WAL usage followed by sudden drop
Next
From: delongboy
Date:
Subject: Re: Increasing WAL usage followed by sudden drop