Re: [GENERAL] A Haunted Database

2000-04-09 Thread Charles Tassell
Vacuuming is sort of necessary at the moment, because if you don't vacuum, postgres won't use your indexes. :( This is supposedly going to be fixed in the 7.x series (7.5 I think I heard) but I've never heard of a vacuum corrupting a normally working database in the 4 or 5 months I've been re

Re: [GENERAL] A Haunted Database

2000-04-09 Thread Tatsuo Ishii
> Thanks! Turning off the nightly vacuum script did the trick. Now . . . any > idea why vacuum would be so damaging? It certainly appears, at least for me, > that the routine is more trouble than it is worth. Is it a malfunction that > can be overwritten or a bug or something else? > > Again many