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 16:51:25
Message-ID: 16094.1308502285@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Jeff Janes" <jeff(dot)janes(at)gmail(dot)com> writes:
> Starting with commit b4b6923e03f4d29636a94f6f4cc2f5cf6298b8c8,
> "Fix VACUUM so that it always updates pg_class.reltuples/relpages."

> 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.

> This has no direct negative effect that I know of, but it seems to be a
> worrying symptom that pg_class or some related entity may not be getting
> updated correctly.

Hmm ... seems worrisome, all right, but I don't see that happening here.
At least I don't see any indication of it in
pg_stat_all_tables.last_autoanalyze.  Are you looking at that, or some
other evidence?  Do you have any nondefault settings?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Jeff DavisDate: 2011-06-19 17:23:10
Subject: Re: PG regression with row comparison when btree_gist is enabled (BUG)
Previous:From: Craig RingerDate: 2011-06-19 09:00:32
Subject: Re: BUG #6064: != NULL, <> NULL do not work

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