Re: [BUGS] BUG #6068: automatic analyze runs endlessly

2011-06-19 Thread Tom Lane
Jeff Janes jeff.ja...@gmail.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

Re: [BUGS] BUG #6068: automatic analyze runs endlessly

2011-06-19 Thread Tom Lane
Jeff Janes jeff.ja...@gmail.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

Re: [BUGS] BUG #6068: automatic analyze runs endlessly

2011-06-19 Thread Jeff Janes
On 6/19/11, Tom Lane t...@sss.pgh.pa.us wrote: Jeff Janes jeff.ja...@gmail.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

[BUGS] BUG #6068: automatic analyze runs endlessly

2011-06-18 Thread Jeff Janes
The following bug has been logged online: Bug reference: 6068 Logged by: Jeff Janes Email address: jeff.ja...@gmail.com PostgreSQL version: 9.1beta1 Operating system: Linux Description:automatic analyze runs endlessly Details: Starting with commit