Re: Teaching users how they can get the most out of HOT in Postgres 14

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Teaching users how they can get the most out of HOT in Postgres 14
Date: 2021-04-12 23:35:13
Message-ID: CAH2-Wz=gFFQ4rnrzZujoToYU4NH14Ehi=gN=hfYtPCNQWn29Lw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Apr 12, 2021 at 4:30 PM Andres Freund <andres(at)anarazel(dot)de> wrote:
> As far as I can see there's no reasonable way to disable this
> "optimization", which scares me.

I'm fine with adding a simple 'off' switch. What I'd like to avoid
doing is making the behavior tunable, since it's likely to change in
Postgres 15 and Postgres 16 anyway.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2021-04-12 23:35:21 Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays
Previous Message Tom Lane 2021-04-12 23:33:02 Re: pg_upgrade check for invalid role-specific default config