Re: Sorting writes during checkpoint - Mailing list pgsql-patches

From Greg Smith
Subject Re: Sorting writes during checkpoint
Date
Msg-id Pine.GSO.4.64.0805041905030.14259@westnet.com
Whole thread Raw
In response to Re: Sorting writes during checkpoint  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Sorting writes during checkpoint  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
On Sun, 4 May 2008, Tom Lane wrote:

> However, I am completely unable to measure any performance improvement
> from it.  Given the possible risk of out-of-memory failures, I think the
> patch should not be applied without some direct proof of performance
> benefits, and I don't see any.

Fair enough.  There were some pgbench results attached to the original
patch submission that gave me a good idea how to replicate the situation
where there's some improvement.  I expect I can take a shot at quantifying
that independantly near the end of this month if nobody else gets to it
before then (I'm stuck sorting out a number of OS level issue right now
before my testing system is online again).  Was planning to take a longer
look at Greg Stark's prefetching work at that point as well.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fix \dT enum in psql
Next
From: Tom Lane
Date:
Subject: Re: temporal version of generate_series()