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 |
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 |