Re: ANALYZE ONLY - Mailing list pgsql-hackers

From David Rowley
Subject Re: ANALYZE ONLY
Date
Msg-id CAApHDvrKY5KGwND7bJbUyTDLmpi64O8Ye1CUSHCJEvaUy0LH4Q@mail.gmail.com
Whole thread Raw
In response to Re: ANALYZE ONLY  (jian he <jian.universality@gmail.com>)
Responses Re: ANALYZE ONLY
List pgsql-hackers
On Mon, 23 Sept 2024 at 15:29, jian he <jian.universality@gmail.com> wrote:
> Given the above context, I am still confused with this sentence in
> sql-analyze.html.
> "If ONLY is specified before the table name, only that table is analyzed."
>
> like in the above sql example, only_inh_parent's child is also being analyzed.

I guess it depends what you define "analyzed" to mean. In this
context, it means gathering statistics specifically for a certain
table.

Would it be more clear if "only that table is analyzed." was changed
to "then statistics are only gathered specifically for that table."?

David



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Using per-transaction memory contexts for storing decoded tuples
Next
From: Tatsuo Ishii
Date:
Subject: Re: Add memory/disk usage for WindowAgg nodes in EXPLAIN