On Mon, 2023-09-11 at 12:57 +0800, Mikhail Balayan wrote:
> Thanks for the idea. I was surprised to find that this is not the way it
> works and the planning time remains the same.
To benefit from the speed gains of a prepared statement, you'd have to execute
it
at least seven times. If a gener
Thanks for the idea. I was surprised to find that this is not the way it
works and the planning time remains the same. To keep the experiment clean,
I ran it several times, first a couple of times explain analyze, then a
couple of times the query itself:
# PREPARE the_query (varchar) AS
SELECT "te
Hi Laurenz,
My bad, I forgot to write that I tried vacuum too, but it didn't help. To
demonstrate the result, I did it again:
# vacuum (analyze, verbose) test_db_bench_1;
INFO: vacuuming "perfkit.public.test_db_bench_1"
INFO: launched 2 parallel vacuum workers for index cleanup (planned: 2)
INF
