Re: Increasing pattern index query speed - Mailing list pgsql-performance

> Is it OK to run
>
> ALTER TABLE rid ALTER COLUMN toode SET STATISTICS 1000
>
> in prod database or should I try to decrease 1000 to smaller value ?
> rid is big increasing table and is changed frequently, mostly by adding
> rows.

pgAdmin shows default_statistic_target value has its default value  10 in
postgresql.conf file

Andrus.