Re: [BUGS] Routine analyze of single column prevents standard autoanalyze from running at all
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomasz Ostrowski <tometzky+pg@ato.waw.pl>
Cc: pgsql-hackers@postgresql.org
Date: 2016-06-06T19:59:37Z
Lists: pgsql-bugs, pgsql-hackers
Attachments
- analyze-conditionally-reset-counter.patch (text/x-diff) patch
I wrote: > Tomasz Ostrowski <tometzky+pg@ato.waw.pl> writes: >> I suppose this is a bug - an analyze, which does not analyze all >> columns, should not reset pg_stat_user_tables(n_mod_since_analyze). What >> do you think? > I'm inclined to think that this is a reasonable complaint. A usage > pattern like that probably hasn't come up before; but now that it has, > it's clear it shouldn't block auto-analyze from happening. Attached is a draft patch for this, which I propose to apply and back-patch. Any objections? regards, tom lane