Hi,
You are right. Too quickly copy-paste on my part :-)
I take this opportunity to add a NOT insignificant detail.
Before executing the select query I clear the cache:
systemctl stop postgresql-16 && sync && echo 3 > /proc/sys/vm/drop_caches && systemctl start postgresql-16
I need to get a performance result even if data is not in cache.
In addition to David's suggestion, consider the pg_prewarm extension: https://www.postgresql.org/docs/current/pgprewarm.html
