Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group