Re: [GENERAL] pg_autovacuum seems to be a neat freak and cleans way

2004-05-18 Thread Matthew T. O'Connor
On Tue, 2004-05-18 at 22:16, Bruce Momjian wrote: > Brian Hirt wrote: > > I've having a strange issue with pg_autovacuum. I have a table with > > about 4 million rows in 20,000 pages. autovacuum likes to vacuum > > and/or analyze it every 45 minutes or so, but it probably doesn't have > > m

Re: [GENERAL] pg_autovacuum seems to be a neat freak and cleans way

2004-05-18 Thread Bruce Momjian
Matthew T. O'Connor wrote: > > > this happens with other big tables too. the autovacuum is from 7.4.2, > > > some information is below. > > > > Oh, 7.4.2. I know we have some known bug and are waiting on a patch for > > it. > > > > Matthew, we need those fixes for pg_autovacuum soon. > > As

Re: [GENERAL] PgSQL 7.4.2 - NaN on Tru64 UNIX

2004-05-18 Thread Tom Lane
Nikola Milutinovic <[EMAIL PROTECTED]> writes: > [ about NaN on Tru64 ] > This compiles on Tru64 4.0D (the compiler swallows it), but fails on > Tru64 UNIX 5.1B. Both basic CC and DTK Compaq CC break on that file > complaining on that constant evaluation. The best way to solve it is to > use sys