On 18.03.2025 15:25, vignesh C wrote:
> On Thu, 27 Feb 2025 at 11:42, vignesh C <vignesh21@gmail.com> wrote:
>> On Thu, 6 Feb 2025 at 16:29, Umar Hayat <postgresql.wizard@gmail.com> wrote:
>>
>> This will include "ONLY" also when we display the tables too:
>> + else if (HeadMatches("ANALYZE"))
>> +
>> COMPLETE_WITH_SCHEMA_QUERY_PLUS(Query_for_list_of_analyzables,
>> "ONLY");
>>
>> like below:
>> postgres=# analyze only t1
>> information_schema. ONLY public. t1
>>
>> The same issue exists with vacuum too:
>> postgres=# vacuum only t1
>> information_schema. ONLY public. t1
> The attached patch has the fixes for the above issue.
>
> Regards,
> Vignesh
Hi,
Thank you for the patch. However, Is it ok if I can't tab 'ONLY' in
VACUUM ANALYZE command?
CREATE TABLE only_parted (a int, b text) PARTITION BY LIST (a);
CREATE TABLE only_parted1 PARTITION OF only_parted FOR VALUES IN (1);
INSERT INTO only_parted VALUES (1, 'a');
VACUUM ANALYZE {Press Tab}
information_schema. only_parted only_parted1 public.
-----------------------------------------------------------------------------
Although it works:
postgres=# VACUUM ANALYZE ONLY only_parted;
WARNING: VACUUM ONLY of partitioned table "only_parted" has no effect
VACUUM
postgres=#
--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC.
