To: "Greg Smith" <gsmith@gregsmith.com>
Cc: "Pg Hackers" <pgsql-hackers@postgresql.org>
Subject: Re: Commitfest patches
In-Reply-To: <Pine.GSO.4.64.0803281350110.2521@westnet.com> (Greg Smith's
	message of "Sun\, 30 Mar 2008 01\:02\:53 -0400 \(EDT\)")
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux)
References: <87wsnnz046.fsf@oxford.xeocode.com>
	<1206697482.4285.1518.camel@ebony.site>
	<87od8zytq9.fsf@oxford.xeocode.com>
	<Pine.GSO.4.64.0803281350110.2521@westnet.com>
From: Gregory Stark <stark@enterprisedb.com>
Organization: EnterpriseDB
Date: Sat, 05 Apr 2008 03:25:57 +0100
Message-ID: <871w5ldolm.fsf@oxford.xeocode.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii


"Greg Smith" <gsmith@gregsmith.com> writes:

> On Fri, 28 Mar 2008, Gregory Stark wrote:
>
>> I described which interfaces worked on Linux and Solaris based on empirical
>> tests. I posted source code for synthetic benchmarks so we could test it on a
>> wide range of hardware. I posted graphs based on empirical results.
>
> Is it possible to post whatever script that generates the graph (gnuplot?) so
> people can compare the results they get to yours?  

Unfortunately I couldn't figure out how to get gnuplot to do this. I ended up
doing it in gnumeric. I'll look into fixing it the script up to be more
automatic. Maybe look at gnuplot again.

> I can run some tests on smaller Linux/Solaris systems to see if they don't show
> a regression, that was my main concern about this experiment.  

Heikki suggested some things to test for regressions. I'll look at that.

What I'm more curious about and hoped I could get data from others is whether
posix_fadvise(WILL_NEED) does anything useful on various versions of FreeBSD,
OSX, etc. Afaict the syscall doesn't exist at all on Solaris though, which
surprises me :(

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's RemoteDBA services!