On Thu, Jun 27, 2024 at 11:33 AM aghart...@gmail.com <aghart...@gmail.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
