Re: Memory Accounting v11

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Memory Accounting v11
Date: 2015-07-06 02:36:46
Message-ID: CAKJS1f_n=_7BdeS_6Jj3O8Z6H2+o5wk5XHSwMTvmHZ4OSTCq9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 15 June 2015 at 07:43, Jeff Davis <pgsql(at)j-davis(dot)com> wrote:

>
> * There was a slowdown reported of around 1-3% (depending on the exact
> version of the patch) on an IBM power machine when doing an index
> rebuild. The results were fairly noisy for me, but it seemed to hold up.
> See http://www.postgresql.org/message-id/CA
> +Tgmobnu7XEn1gRdXnFo37P79bF=qLt46=37ajP3Cro9dBRaA(at)mail(dot)gmail(dot)com

Hi Jeff,

I've been looking over the code and reason the previous emails about this
patch.
I don't yet understand if the reported slowdown is from the increase in
struct size or from the additional work being done in palloc() calls,
however, on reading the code I did notice an existing redundant NULL check
in AllocSetAlloc() right where you put you're extra accounting code.

The attached patch should apply on top of your patch and removes the extra
NULL check.

Perhaps if some over the overhead is the extra instructions then this can
help get us back to where we were before.

Regards

David Rowley

--
David Rowley http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Training & Services

Attachment Content-Type Size
duplicate_null_check_removal.diff text/plain 819 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2015-07-06 03:30:50 Re: Let PostgreSQL's On Schedule checkpoint write buffer smooth spread cycle by tuning IsCheckpointOnSchedule?
Previous Message Michael Paquier 2015-07-06 01:38:42 Re: Fix broken Install.bat when target directory contains a space