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

2024-07-17 Thread Pierrick Chovelon
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" ? Something to

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

2024-07-16 Thread Tomas Vondra
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" ? > Something to do with the planner ? optimizer ? > > (We executed the same test with a bt