On 18.03.2025 17:57, Ilia Evdokimov wrote:
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.


Umar, Vignesh, sorry for not adding you to CC earlier!

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC.



Reply via email to