Differents execution times with gin index, prepared statement and literals.

Hello, One of our customer is facing an issue regarding a prepared statement and a gin index. An important gap between execution times can be shown when using execute or plain literals. Here is the test that shown this issue : Init table : create table tmp_tk_test_index (     sync_id   

Re: Differents execution times with gin index, prepared statement and literals.

Hello, Thanks a lot for your clear answer. On 16/07/2024 19:54, Tomas Vondra wrote: On 7/16/24 17:43, Pierrick Chovelon wrote: ... Quite fast as well... Have you got an idea on the initial issue ? Why when using a prepared statement and a gin index the execution time "explode" ?