Stats Collector Error 7.4beta1 and 7.4beta2

From: Adam Kavan <akavan(at)cox(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Stats Collector Error 7.4beta1 and 7.4beta2
Date: 2003-09-04 02:50:35
Message-ID: 20030904025035.UMLC19774.lakemtao08.cox.net@smtp.central.cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was attempting to get pg_autovacuum to work on my database and after much hammering at it I discovered that the stats system was not working. I tried it with both 7.4beta1 and 7.4beta2 in both cases the number of tuples inserted, deleted and updated remained at 0 no matter what database activity occured.

Matthew T. O'Connor looked at my system recompiled postgres, and checked my config files and was unable to solve my problem.

I am using a default install of RedHat 9.0 on a VIA Samuel 2 processor. Anyone have any ideas what could be causing my problem? I have had hardware problems in the past but this is a new machine that I ran memtest86 and badblocks with the destructive tests on before I installed so I'm pretty sure thats not the issue. Additionally I made a copy of the hard drive and placed it in another server and saw the same thing happen.

I did not have this problem with 7.3.3 so I think it has something to do with 7.4.

--- Adam Kavan--- akavan(at)cox(dot)net

--- Adam Kavan
--- American Amuesments
--- akavan(at)cox(dot)net
--- 402-499-5145

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-09-04 02:55:59 Re: Transaction status in default psql prompt?
Previous Message Martijn van Oosterhout 2003-09-04 02:40:11 Re: Using oids