| 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: | Whole Thread | Raw Message | 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
| 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 |