Dawid Kuroczko <qnex42(at)gmail(dot)com> writes:
> Basically it tells postgres how many values should it keep for
> statistics per column. The config default_statistics_target
> is the default (= used when creating table) and ALTER... is
> a way to change it later.
Not quite. default_statistics_target is the value used by ANALYZE for
any column that hasn't had an explicit ALTER SET STATISTICS done on it.
So you can change default_statistics_target and that will affect
existing tables.
(It used to work the way you are saying, but that was a few releases
back...)
regards, tom lane