Horton

Re: vacuum analyze query performance - help me understand

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Scot Kreienkamp <Scot.Kreienkamp@la-z-boy.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-08-19T20:28:35Z
Lists: pgsql-general 
On Tue, Aug 19, 2025 at 10:37 AM Scot Kreienkamp <
Scot.Kreienkamp@la-z-boy.com> wrote:

>
> We ran a (admittedly poorly written) select query against a subset of
> tables which performed poorly.  Then we ran a vacuum analyze against just
> those tables involved in that query, then ran the same query again, which
> performed exponentially better.


Did/can you observe query buffer usage/performance for the two explain
analyze executions?

David J.