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

Re: basic pgbench runs with various performance-related patches

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: basic pgbench runs with various performance-related patches
Date: 2012-01-24 00:52:51
Message-ID: CA+U5nMJdmWDB9UapWU5hvQUtHxsHZLA3f+k86VYHUaGZ8B-zVg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, Jan 23, 2012 at 3:49 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

>> The other patches have clearer and specific roles without heuristics
>> (mostly), so are at least viable for 9.2, though still requiring
>> agreement.
>
> I think we must also drop removebufmgrfreelist-v1 from consideration,
...

I think you misidentify the patch. Earlier you said it that
"buffreelistlock-reduction-v1 crapped
out"  and I already said that the assumption in the code clearly
doesn't hold, implying the patch was dropped.

The removebufmgrfreelist and its alternate patch is still valid, with
applicability to special cases.

I've written another patch to assist with testing/assessment of the
problems, attached.

-- 
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Attachment: freelist_wait_stats.v2.patch
Description: text/x-patch (5.4 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Daniel FarinaDate: 2012-01-24 00:59:17
Subject: Re: Inline Extension
Previous:From: Noah MischDate: 2012-01-24 00:18:59
Subject: Re: Measuring relation free space

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