4 ms·
These days it does analyze in stages where it does multiple passes with increasing stats sampling. From personal experience, most of the queries become useable
by pilif 2y ago
These days it does analyze in stages where it does multiple passes with increasing stats sampling.
From personal experience, most of the queries become useable after the first stage has completed which on my 8TB database took less than 5 minutes
- timacles 2y agoWe did use the --analyze-in-stages option, I think our data model is just not optimal. We have a lot of high frequency queries hitting very large tables of .5 to 1 billion rows. Proper indexing makes them fast but until all the stats are there, the frontend is unusable.