On 14 February 2017 at 06:19, Seki, Eiji <seki.e...@jp.fujitsu.com> wrote: > In our benchmark, we found that waiting an ANALYZE process created by > autovacuum daemon often has a significant impact to the performance although > the waited process do only reading as to the table. ... > I'm not sure that this feature is useful in general. > Please let me know your opinion if you are interested.
You mention the above problem and hypothesise a solution. IMHO the discussion on this is the wrong way around. First we must be certain that the solution is effective and has no problems, then we decide how to code it or discuss APIs. If you do this, ANALYZE will see an inconsistent view of data in the table, biasing its view towards data not recently updated, which might also have a negative performance effect. Please persuade us with measurements that allowing this impact on ANALYZE would really improve performance at least in your case, and also examine the effect of this on the accuracy and usefulness of the gathered statistics. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
