Re: profiling connection overhead - Mailing list pgsql-hackers

From Andres Freund
Subject Re: profiling connection overhead
Date
Msg-id 201011300821.30383.andres@anarazel.de
Whole thread Raw
In response to Re: profiling connection overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Monday 29 November 2010 19:10:07 Tom Lane wrote:
> Jeff Janes <jeff.janes@gmail.com> writes:
> > Are you sure you haven't just moved the page-fault time to a part of
> > the code where it still exists, but just isn't being captured and
> > reported?
> 
> I'm a bit suspicious about that too.  Another thing to keep in mind
> is that Robert's original program doesn't guarantee that the char
> array is maxaligned; though reasonable implementations of memset
> should be able to use the same inner loop anyway for most of the
> array.
Yes, I measured the time including mmap itself. I don't find it surprising its 
taking measurably shorter as it can just put up the mappings without 
explicitly faulting for each and every page. The benefit is too small to worry 
though, so ...

The answer to Robert includes the timings + test program.

Andres


pgsql-hackers by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: DELETE with LIMIT (or my first hack)
Next
From: Heikki Linnakangas
Date:
Subject: Re: crash-safe visibility map, take three