How to delete column level Stats/Histogram

["Wong, Kam Fook (TR Technology)" <kamfook.wong@xxxxxxxxxxxxxxxxxx>]

1. Is there a way to delete a specific column level stats/histogram.  The following approach does not work.

 

alter table abc alter column bg_org_partner set statistics 0;

analyze   abc;

 

select *

FROM pg_stats where tablename in ('abc' ) and attname = 'bg_org_partner';

 

the most_common_vals remain and most_common_freqs remain the same.

 

2. Any other ways or workaround such as wiping out a specific table level stat, then restore the stats but minus 1 column.  And the future vacuum analyze/analyze will not be updating that specific column stat. 

 

Thank you

This e-mail is for the sole use of the intended recipient and contains information that may be privileged and/or confidential. If you are not an intended recipient, please notify the sender by return e-mail and delete this e-mail and any attachments. Certain required legal entity disclosures can be accessed on our website: https://www.thomsonreuters.com/en/resources/disclosures.html