Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

			regards, tom lane

In response to

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group