Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey
Date
Msg-id CA+Tgmoa7DqM09jTF6ts3bifdcEZ8oY-9vOQbtCSDPx_r5n5a5Q@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [HACKERS] rewrite HeapSatisfiesHOTAndKey
List pgsql-hackers
On Mon, Jan 2, 2017 at 1:36 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> Okay, but I think if we know how much is the additional cost in
> average and worst case, then we can take a better call.

Yeah.  We shouldn't just rip out optimizations that are inconvenient
without doing some test of what the impact is on the cases where those
optimizations are likely to matter.  I don't think it needs to be
anything incredibly laborious and if there's no discernable impact,
great.  But it doesn't make sense to change things for the benefit of
WARM and indirect indexes and then discover later that we regressed
other cases we care about and have no plan to fix it.  Better to find
out any potential problems of that kind now.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Broken atomics code on PPC with FreeBSD 10.3
Next
From: David Fetter
Date:
Subject: Re: [HACKERS] PoC: Make it possible to disallow WHERE-less UPDATEand DELETE