public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Scot Kreienkamp <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: vacuum analyze query performance - help me understand
Date: Tue, 19 Aug 2025 13:28:35 -0700
Message-ID: <CAKFQuwbhnw7XbSqsCV+zDfDQjzWx0_pXN_WKByGKBpQz9VLYXA@mail.gmail.com> (raw)
In-Reply-To: <SJ0PR15MB524590D2BECF3283CDCE39289A30A@SJ0PR15MB5245.namprd15.prod.outlook.com>
References: <a2cd8084-b93e-4da0-8999-569a6e58ef6b.8f62f83c-ab51-428e-98d1-ab1abb243a49.f9527220-afca-46a5-9ff9-6943b4d51eeb@emailsignatures365.codetwo.com>
<a2cd8084-b93e-4da0-8999-569a6e58ef6b.b1460fbe-55a2-4060-995f-39f4e2f3c7f9.62e1aa37-6482-4ce2-8283-21c365f4f47c@emailsignatures365.codetwo.com>
<SJ0PR15MB524590D2BECF3283CDCE39289A30A@SJ0PR15MB5245.namprd15.prod.outlook.com>
On Tue, Aug 19, 2025 at 10:37 AM Scot Kreienkamp <
[email protected]> 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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: vacuum analyze query performance - help me understand
In-Reply-To: <CAKFQuwbhnw7XbSqsCV+zDfDQjzWx0_pXN_WKByGKBpQz9VLYXA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox