Dimitri <dimitrik...@gmail.com> writes:
> Anyone may explain me why analyze target may have so huge negative
> secondary effect?..
If these are simple queries, maybe what you're looking at is the
increase in planning time caused by having to process 10x as much
statistical data. Cranking statistics_target to the max just because
you can is not necessarily a good strategy.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
