How to tell ANALYZE to collect statistics from the whole table?
| От | AlexK987 |
|---|---|
| Тема | How to tell ANALYZE to collect statistics from the whole table? |
| Дата | |
| Msg-id | 1422142399144-5835339.post@n5.nabble.com обсуждение |
| Ответы |
Re: How to tell ANALYZE to collect statistics from the
whole table?
Re: How to tell ANALYZE to collect statistics from the whole table? |
| Список | pgsql-performance |
The documentation states that "The extent of analysis can be controlled by adjusting the default_statistics_target configuration variable". It looks like I can tell Postgres to create more histograms with more bins, and more distinct values. This implicitly means that Postgres will use a larger random subset to calculate statistics. However, this is not what I want. My data may be quite skewed, and I want full control over the size of the sample. I want to explicitly tell Postgres to analyze the whole table. How can I accomplish that? -- View this message in context: http://postgresql.nabble.com/How-to-tell-ANALYZE-to-collect-statistics-from-the-whole-table-tp5835339.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
В списке pgsql-performance по дате отправления: