Re: BUG #6068: automatic analyze runs endlessly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeff Janes" <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6068: automatic analyze runs endlessly
Date: 2011-06-19 17:31:48
Message-ID: 17359.1308504708@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Jeff Janes" <jeff(dot)janes(at)gmail(dot)com> writes:
> After running make installcheck, the tables regression.public.slow_emp4000
> and regression.public.fast_emp4000 get analyzed once a minute even though
> they have no activity. None of the other installcheck tables, just those
> two.

Oh, wait, I see what's different about those two tables: they have no
analyzeable columns. I thinko'd what to do in that situation. Will
fix.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2011-06-19 17:35:26 Re: BUG #6068: automatic analyze runs endlessly
Previous Message Jeff Davis 2011-06-19 17:23:10 Re: PG regression with row comparison when btree_gist is enabled (BUG)