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
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
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
