ANALYZING EFFECT ON DEFAULT_STATISTICS_TARGET ON ANALYZE
Denish Patel, Solutions Engineering, Database Architect
![Denish Patel, Solutions Engineering, Database Architect]()
Denish Patel, Solutions Engineering, Database Architect
If you are working with Postgres database servers, I wrote a blog on one of the settings in Postgres for performance tuning on my blog website.
Hope this will help.
Lou, agreed! I have seen people comparing postgres performance with other dbs by running Postgres with default configuration and decide it is slow !
Very good stuff, Denish! I think you correctly cut to the core here; that the vast majority of PostgreSQL clusters out there are not benefiting from the great advantages to be gained by careful analysis and (re)configuration. This is certainly a recurring theme in our work. And ++ for PostgreSQL, and the power of its configure-ability.