If you do a delete on the first step without any statistics, you request will
do a full scan of the table, which will be slower.
Did you check the different execution plans ?
From: Szalontai Zoltán
Sent: Thursday, April 8, 2021 01:24 PM
To: pgsql-performance@li
You now that Postgres don’t have any shared_pool as Oracle, and the session
information ( execution plan, etc..) are only available for the current
session. Therefore I also highly recommend to us a connection poll as Laurent
wrote, in order to have higher chance that some stuff is already cach
