On Thu, Jun 27, 2024 at 11:33 AM agharta82(at)gmail(dot)com <agharta82(at)gmail(dot)com>
wrote:
> 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