Re: Performance of Seq Scan from buffer cache

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Matt Daw <matt(at)shotgunsoftware(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance of Seq Scan from buffer cache
Date: 2012-08-23 13:32:12
Message-ID: CAHyXU0zzdWBpjy8GkjAQjCOAR4UD2KH+ztJGLqSKV4Fn+PLR_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Aug 21, 2012 at 6:59 PM, Matt Daw <matt(at)shotgunsoftware(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message delongboy 2012-08-23 14:43:18 Re: Increasing WAL usage followed by sudden drop
Previous Message Jeff Janes 2012-08-23 00:28:45 Re: Increasing WAL usage followed by sudden drop