Re: ANALYZE ONLY - Mailing list pgsql-hackers

From Michael Harris
Subject Re: ANALYZE ONLY
Date
Msg-id CADofcAW=JDNdPy=dbQK9b4AsZKbqdSDTwg2=fkriq+KbnDZ-DA@mail.gmail.com
Whole thread Raw
In response to Re: ANALYZE ONLY  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ANALYZE ONLY
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Yeah, my thought was to change the behavior so it's consistent in
> that case too.  This doesn't seem to me like a change that'd
> really cause anybody serious problems: ANALYZE without ONLY would
> do more than before, but it's work you probably want done anyway.

Would we want to apply that change to VACUUM too? That might be a
bit drastic, especially if you had a multi-level inheritance structure featuring
large tables.

It feels a bit like VACUUM and ANALYZE have opposite natural defaults here.
For VACUUM it does not make much sense to vacuum only at the partitioned
table level and not include the partitions, since it would do nothing
- that might
be why the existing code always adds the partitions.



pgsql-hackers by date:

Previous
From: Andy Fan
Date:
Subject: Measure the servers's IO performance
Next
From: jian he
Date:
Subject: Re: pgsql: Add more SQL/JSON constructor functions