Re: [HACKERS] Hint Bits and Write I/O - Mailing list pgsql-patches

From Simon Riggs
Subject Re: [HACKERS] Hint Bits and Write I/O
Date
Msg-id 1216730673.3894.308.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: [HACKERS] Hint Bits and Write I/O  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Mon, 2008-07-21 at 16:33 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > On Mon, 2008-07-21 at 11:36 +0530, Pavan Deolasee wrote:
> >> I think we should try at least one or two possible optimizations and
> >> get some numbers before we jump and make substantial changes to the
> >> code.
>
> > You know you're suggesting months of tests and further discussion. :-(
>
> I agree with Pavan that we should have something that'd at least serve
> as test scaffolding to verify that the framework patch is sane.  The
> test code needn't be anything we'd want to commit.

The test code is/was there, in the sense that the patch was (supposed
to) do exactly what it does now, just with extra code to keep track of
hint counts.

Probably the most important point is not yet covered: we don't keep any
track of which blocks are dirtied solely for hint bits. We need to do
this so we can measure the efficacy of *any* patch that seeks to improve
the current situation.

The best time to do this is in integration phase of release, so will do
it then.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pg_dump additional options for performance
Next
From: Martin Zaun
Date:
Subject: Re: [HACKERS]odd output in restore mode