On Mon, May 04, 2020 at 08:07:07PM +0100, Jamie Thompson wrote: > Additionally, the execution plans for the 10th + following queries look > fine, they have the same structure as if I run the query manually. It's not > that the query plan switches, it seems as though the same query plan is > just > 200X slower than usual.
Are you able to reproduce the problem manually ? With/without PREPARE ? https://www.postgresql.org/docs/current/sql-prepare.html -- Justin
