Re: vacuum analyze query performance - help me understand

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Scot Kreienkamp <Scot(dot)Kreienkamp(at)la-z-boy(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: vacuum analyze query performance - help me understand
Date: 2025-08-19 20:28:35
Message-ID: CAKFQuwbhnw7XbSqsCV+zDfDQjzWx0_pXN_WKByGKBpQz9VLYXA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 19, 2025 at 10:37 AM Scot Kreienkamp <
Scot(dot)Kreienkamp(at)la-z-boy(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fujii Masao 2025-08-20 04:31:29 Re: analyze-in-stages post upgrade questions
Previous Message Scot Kreienkamp 2025-08-19 20:25:26 RE: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug