How to delete column level Stats/Histogram
От | Wong, Kam Fook (TR Technology) |
---|---|
Тема | How to delete column level Stats/Histogram |
Дата | |
Msg-id | CH0PR03MB61008E885DA648855B38E273FEF32@CH0PR03MB6100.namprd03.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: How to delete column level Stats/Histogram
|
Список | pgsql-general |
- 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.
- 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
В списке pgsql-general по дате отправления: