Re: Multicolumn index scan efficiency

2025-11-10 Thread Peter Geoghegan
On Mon, Nov 10, 2025 at 12:12 AM Vitalii Tymchyshyn wrote: > Thank you so much for both clarifying and fixing it! FWIW the problem is limited to row compares/row constructor comparisons that are used to decide when to end the scan. Note in particular that row compares that decide where in the ind

Re: Multicolumn index scan efficiency

2025-11-09 Thread Vitalii Tymchyshyn
Thank you so much for both clarifying and fixing it! In our case (FYI, this is from http://github.com/cdapio/cdap) a lot of users have just a single namespace, so it effectively means scanning till the end of the index. We'll fix https://github.com/cdapio/cdap/blob/develop/cdap-data-fabric/src/main

Re: Multicolumn index scan efficiency

2025-11-09 Thread Peter Geoghegan
On Sun, Nov 9, 2025 at 9:44 PM Vitalii Tymchyshyn wrote: > I am wondering about 2 things: > 1) Does anyone know which specific change / version made it fast? > 2) What was the proper way to do a range index scan like WHERE (a,b,c) > between (x1,y1,z1) and (x2,y2,z2) before the improvement. > Note