Hi Justin, Yes, it is using index scan, which makes me even more puzzled.
On Tuesday, May 22, 2018 at 3:45:29 PM UTC+7, Justin Israel wrote: > > > > On Tue, May 22, 2018, 6:35 PM Hawari Rahman <hawari....@gmail.com > <javascript:>> wrote: > >> After some more detailed investigation, it seems the most time consuming >> process is a "Select by IDs" query. So to hydrate a Collection object, I >> need to retrieve another objects through a SELECT WHERE id = ANY(?)" query >> in postgres. I'm curious on how the performance can differs greatly when >> concurrency is introduced. >> > > Is the query doing a table scan vs using the index? > >> -- >> You received this message because you are subscribed to the Google Groups >> "golang-nuts" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to golang-nuts...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "golang-nuts" group. To unsubscribe from this group and stop receiving emails from it, send an email to golang-nuts+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
