On Wed, Mar 31, 2021 at 12:38:14PM +0530, Vineet Naik wrote: > > This option will try to create some statistics as fast as possible, to make the database usable, and then produce full statistics in the subsequent stages. > > So my question is, after which stage is it ok to send traffic to the > server without much performance impact? Also, is it possible to query > the stats view in pg and determine if enough stats have been > generated? That is a very hard question to answer. Some queries have only a few possible plans, so few or no statistics are fine. Other queries require detailed statistics to generate efficient plans. I think you need to set up a dummy server with no stats and try your workload on that, then run the stages manually and test after each stage to see how the performance is. -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
