Conversation

Notices

1. Oneesan succubus (lain@pleroma.soykaf.com@pleroma.soykaf.com)'s status on Thursday, 21-Nov-2019 19:13:40 JST Oneesan succubus

   • Oneesan succubus
   apparently postgres will build different query plans for
   
   SELECT * from table where key = 1 or key = 2
   
   and
   
   SELECT * from table where key in (1, 2)
   
   source: https://www.cybertec-postgresql.com/en/avoid-or-for-better-performance/
   • Sorokin Alexei (xrevan86@loadaverage.org)'s status on Friday, 22-Nov-2019 09:00:23 JST Sorokin Alexei

     in reply to
     @lain I didn't know that MariaDB will in fact build the same query plans for these two queries. Had to check.