Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: XINYULIU(at)umich(dot)edu, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification
Date: 2020-09-23 19:22:52
Message-ID: CAH2-WznKMCs=g13dqo-8GgMdD5ik6HZ798B41_mnNnRMzFWLwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Sep 18, 2020 at 2:22 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Unfortunately, that's a viewpoint that is not going to win you a lot of
> converts.

I think that this perspective is held by all groups that works on
query optimization, not just the PostgreSQL developers:

https://use-the-index-luke.com/sql/where-clause/obfuscation/math

Evidently nobody even tries to do this stuff.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Zsolt Ero 2020-09-23 19:26:34 Re: BUG #16604: pg_dump with --jobs breaks SSL connections
Previous Message PG Bug reporting form 2020-09-23 18:41:29 BUG #16631: postgres_fdw tries to insert into generated columns