Re: ANALYZE ONLY

On 20.8.24 10:42, Jelte Fennema-Nio wrote:

> On Tue, 20 Aug 2024 at 07:52, Michael Harris<harmic@gmail.com>  wrote:
>>    1. Would such a feature be welcomed? Are there any traps I might not
>> have thought of?
> I think this sounds like a reasonable feature.
>
>
>>    2. The existing ANALYZE command has the following structure:
>>
>>       ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ]
>>
>>       It would be easiest to add ONLY as another option, but that
>> doesn't look quite
>>       right to me - surely the ONLY should be attached to the table name?
>>       An alternative would be:
>>
>>       ANALYZE [ ( option [, ...] ) ] [ONLY] [ table_and_columns [, ...] ]
>>
>> Any feedback or advice would be great.
> Personally I'd prefer a new option to be added. But I agree ONLY isn't
> a good name then. Maybe something like SKIP_PARTITIONS.
>

Hi everyone,

Your proposal is indeed interesting, but I have a question: can't your 
issue be resolved by properly configuring |autovacuum| instead of 
developing a new feature for |ANALYZE|?

 From my perspective, |ANALYZE| is intended to forcibly gather 
statistics from all partitioned tables. If the goal is to ensure that 
statistics are updated at the right moment, adjusting the 
|autovacuum_analyze_threshold| and |autovacuum_analyze_scale_factor| 
parameters might be the solution.

-- 
Regards,
Ilia Evdokimov,
Tantor Labs LCC.