public inbox for [email protected]
help / color / mirror / Atom feedFrom: Wong, Kam Fook (TR Technology) <[email protected]>
To: [email protected] <[email protected]>
Subject: How to delete column level Stats/Histogram
Date: Thu, 30 May 2024 21:27:56 +0000
Message-ID: <CH0PR03MB61008E885DA648855B38E273FEF32@CH0PR03MB6100.namprd03.prod.outlook.com> (raw)
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.
1. 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
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: How to delete column level Stats/Histogram
In-Reply-To: <CH0PR03MB61008E885DA648855B38E273FEF32@CH0PR03MB6100.namprd03.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox