Dimitri <dimitrik.fr@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
