Re: Fwd: different execution time for the same query (and same DB status)

Subject: Re: Fwd: different execution time for the same query (and same DB status)
From: Michael Lewis <mlewis@xxxxxxxxxxx>
Date: Wed, 10 Mar 2021 06:29:18 -0700
Cc: Justin Pryzby <pryzby@xxxxxxxxxxxxx>, Pgsql Performance <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, Julien Rouhaud <rjuju123@xxxxxxxxx>, Michel SALAIS <msalais@xxxxxxx>
In-reply-to: <CAHWr2CeYh=N9pB3bQUEuC0ZCfuOSbXyex+A1pMTYw58VAGjBSQ@mail.gmail.com>
References: <CAHWr2Cfhfx=9CUP1gKPY-9aw02UrijsE=YKD3FcmxfYZoSZTHA@mail.gmail.com> <CAHWr2CeC_Q+kOBY7O3HmX1qVRHch26yiDw6HeUZGGaBpANubVQ@mail.gmail.com> <20210310082753.GR2021@telsasoft.com> <CAHWr2CeYh=N9pB3bQUEuC0ZCfuOSbXyex+A1pMTYw58VAGjBSQ@mail.gmail.com>

I would increase shared_buffers to 1GB or more. Also, it would be very interesting to see these queries executed with JIT off.

Follow-Ups:
- Re: Fwd: different execution time for the same query (and same DB status)
  - From: Francesco De Angelis

References:
- Re: different execution time for the same query (and same DB status)
  - From: Francesco De Angelis
- Fwd: different execution time for the same query (and same DB status)
  - From: Francesco De Angelis
- Re: Fwd: different execution time for the same query (and same DB status)
  - From: Justin Pryzby
- Re: Fwd: different execution time for the same query (and same DB status)
  - From: Francesco De Angelis