Postgres Pro
Downloads
Home   >   mailing lists

Re: A way to optimize sql about the last temporary-related row - Mailing list pgsql-general

From Ron Johnson
Subject Re: A way to optimize sql about the last temporary-related row
Date
Msg-id CANzqJaDP92SxE+y1VpVr1TXfKhJ-DKwTOtNxetwnyL0qs2eWxg@mail.gmail.com
Whole thread Raw
In response to Re: A way to optimize sql about the last temporary-related row  ("agharta82@gmail.com" <agharta82@gmail.com>)
List pgsql-general
Tree view
On Thu, Jun 27, 2024 at 11:33 AM agharta82@gmail.com <agharta82@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
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: A way to optimize sql about the last temporary-related row
Next
From: "David G. Johnston"
Date:
Subject: Re: dblink Future support vs FDW