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

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Francesco De Angelis <franc(dot)tozzus(at)gmail(dot)com>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, Michel SALAIS <msalais(at)msym(dot)fr>
Subject: Re: Fwd: different execution time for the same query (and same DB status)
Date: 2021-03-10 13:29:18
Message-ID: CAHOFxGoOZAuJXotzzwdBeXowbgAsHGHr7U_0P2XPfQo-2gLWWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2021-03-11 14:29:45 Re: FreeBSD UFS & fsync
Previous Message Francesco De Angelis 2021-03-10 11:48:25 Re: Fwd: different execution time for the same query (and same DB status)