Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)

From:	Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To:	Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>
Cc:	Peter Geoghegan <pg(at)bowt(dot)ie>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)
Date:	2023-12-27 12:36:18
Message-ID:	CAPpHfduFd=0vi97Osm0fLHZmN8vx4d7kgZCdwMLjt251fkb+CA@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2023-12-06 00:41:06 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎  2023-12-06 00:53:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2023-12-06 01:14:23 from Peter Geoghegan <pg(at)bowt(dot)ie>    2023-12-06 13:11:32 from Robert Haas <robertmhaas(at)gmail(dot)com>     2023-12-06 13:27:24 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>      2023-12-06 13:32:13 from Robert Haas <robertmhaas(at)gmail(dot)com>      2023-12-06 16:44:16 from Peter Geoghegan <pg(at)bowt(dot)ie>      2023-12-06 18:54:45 from Peter Geoghegan <pg(at)bowt(dot)ie>       2023-12-06 19:14:24 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>        2023-12-06 19:50:16 from Peter Geoghegan <pg(at)bowt(dot)ie>  2023-12-06 01:45:41 from Peter Geoghegan <pg(at)bowt(dot)ie> 📎   2023-12-06 04:05:52 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>    2023-12-06 04:20:01 from Peter Geoghegan <pg(at)bowt(dot)ie>     2023-12-06 17:31:56 from Peter Geoghegan <pg(at)bowt(dot)ie>    2023-12-08 18:30:18 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>     2023-12-08 18:46:01 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎      2023-12-09 02:29:17 from Peter Geoghegan <pg(at)bowt(dot)ie>       2023-12-11 15:56:13 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>        2023-12-11 16:16:07 from Peter Geoghegan <pg(at)bowt(dot)ie>         2023-12-12 13:22:16 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>          2023-12-24 22:50:52 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎           2023-12-25 18:32:37 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>            2023-12-26 19:35:37 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎             2023-12-27 11:18:35 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>              2023-12-27 12:36:18 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>               2024-03-22 07:29:38 from "Anton A(dot) Melnikov" <a(dot)melnikov(at)postgrespro(dot)ru>                2024-03-22 08:02:49 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com> 📎                 2024-03-22 08:14:48 from "Anton A(dot) Melnikov" <a(dot)melnikov(at)postgrespro(dot)ru>                  2024-03-22 09:58:28 from Maxim Orlov <orlovmg(at)gmail(dot)com>                   2024-03-22 13:26:47 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>        2023-12-11 18:59:32 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎
Lists:	pgsql-hackers

In response to

• Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) at 2023-12-27 11:18:35 from Pavel Borisov

Responses

• Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) at 2024-03-22 07:29:38 from Anton A. Melnikov

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Peter Eisentraut	2023-12-27 12:42:17	Re: Add support for __attribute__((returns_nonnull))
Previous Message	Alexander Korotkov	2023-12-27 12:21:08	Re: Failed assertion in joininfo.c, remove_join_clause_from_rels