Mark Kirkwood wrote:

Looks to me like -O2 makes the difference very small (on this platform/gcc combo) - is 5/169 worth doing?


Ahem - misunderstood your comment here, sorry.

Qingqing Zhou wrote:

compiled with "gcc testbuf.c". I tried -O2 actually, and it turns out that
the timing is reduced a lot so not believable.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to