Dimitri <dimitrik(dot)fr(at)gmail(dot)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
In response to
pgsql-performance by date
|Next:||From: Stefan Kaltenbrunner||Date: 2009-05-11 16:05:25|
|Subject: Re: PostgreSQL with PostGIS on embedded hardware|
|Previous:||From: Dimitri||Date: 2009-05-11 15:18:31|
|Subject: Re: Any better plan for this query?..|