Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification
Date
Msg-id CAH2-WznKMCs=g13dqo-8GgMdD5ik6HZ798B41_mnNnRMzFWLwA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #16624: Query Optimizer - Performance bug related to predicate simplification  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Fri, Sep 18, 2020 at 2:22 PM Tom Lane <tgl@sss.pgh.pa.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



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16631: postgres_fdw tries to insert into generated columns
Next
From: Zsolt Ero
Date:
Subject: Re: BUG #16604: pg_dump with --jobs breaks SSL connections