Horton

Re: ANALYZE ONLY

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: jian he <jian.universality@gmail.com>
Cc: Michael Harris <harmic@gmail.com>, torikoshia <torikoshia@oss.nttdata.com>, Melih Mutlu <m.melihmutlu@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Robert Haas <robertmhaas@gmail.com>, postgres@jeltef.nl, ilya.evdokimov@tantorlabs.com
Date: 2024-09-23T04:46:21Z
Lists: 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

Commits

  1. Add ONLY support for VACUUM and ANALYZE