Re: Re: Spilling hashed SetOps and aggregates to disk - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Re: Spilling hashed SetOps and aggregates to disk
Date
Msg-id 1528219776.2742.42.camel@j-davis.com
Whole thread Raw
In response to RE: Re: Spilling hashed SetOps and aggregates to disk  (serge@rielau.com)
List pgsql-hackers
On Tue, 2018-06-05 at 08:39 -0700, serge@rielau.com wrote:
> Strange. We don't see this overeahd and measure a lot more than just
> a single metric:

Let's investigate again. I wasn't able to repro the overhead on x86;
Robert saw it on a POWER machine, and it was somewhat noisy. I don't
think we were ever very sure the overhead existed.

My basic opinion is that we make small changes all the time that may
have a small performance impact, and we shouldn't let that become a
blocker for an important feature. Nor should we let it make the design
overly complicated or awkward. We should just see what we can
reasonably do to understand and mitigate it.

Regards,
    Jeff Davis



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [PATCH] Trim trailing whitespace in vim and emacs
Next
From: Andres Freund
Date:
Subject: Variable-length FunctionCallInfoData