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

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