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

BUG #6068: automatic analyze runs endlessly

From: "Jeff Janes" <jeff(dot)janes(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6068: automatic analyze runs endlessly
Date: 2011-06-18 22:32:24
Message-ID: 201106182232.p5IMWOZR013117@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6068
Logged by:          Jeff Janes
Email address:      jeff(dot)janes(at)gmail(dot)com
PostgreSQL version: 9.1beta1
Operating system:   Linux
Description:        automatic analyze runs endlessly
Details: 

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.

Responses

pgsql-bugs by date

Next:From: Craig RingerDate: 2011-06-19 09:00:32
Subject: Re: BUG #6064: != NULL, <> NULL do not work
Previous:From: Tom LaneDate: 2011-06-18 20:30:51
Subject: Re: BUG #6067: In PL/pgsql, EXISTS(SELECT ... INTO...) fails

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