On 11/7/2024 21:59, FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) wrote:

Hello, and thank you again for your example !

Sorry for my late answer, I was working on a patch for our requests. I am though not completely understanding what is happening. Here is a plan of a query where I splitted the calls with OR as you suggested, what seemed to have enabled parallel scans.
Thanks for the feedback!
Generally, I don't understand why you needed to transform ANY -> OR at all to get BitmapScan. Can you just disable IndexScan and possibly SeqScan to see is it a hard transformation limit or mistake in cost estimation?

--
regards, Andrei Lepikhov



  • ... Andrei Lepikhov
    • ... FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
      • ... Andrei Lepikhov
        • ... FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
          • ... FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
            • ... David G. Johnston
            • ... Andrei Lepikhov
          • ... Andrei Lepikhov

Reply via email to