[PERFORM] vacuuming problems continued

2006-06-01 Thread Antoine
Hi, We just don't seem to be getting much benefit from autovacuum. Running a manual vacuum seems to still be doing a LOT, which suggests to me that I should either run a cron job and disable autovacuum, or just run a cron job on top of autovacuum. The problem is that if I run the same query (an up

Re: [PERFORM] vacuuming problems continued

2006-06-01 Thread Tom Lane
Antoine <[EMAIL PROTECTED]> writes: > We just don't seem to be getting much benefit from autovacuum. Running > a manual vacuum seems to still be doing a LOT, which suggests to me > that I should either run a cron job and disable autovacuum, or just > run a cron job on top of autovacuum. The defaul

[PERFORM] help me problems with pg_clog file

2006-06-01 Thread Joao
when i try do \d in psql on a table i get this message! this happens too when i try to run pg_dump...   ERROR:  could not access status of transaction 4294967295DETAIL:  could not open file "pg_clog/0FFF": File or directory not found     someone could help me?? PleasE!    

Re: [PERFORM] Bulk loading/merging

2006-06-01 Thread Michael Artz
On 5/30/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: Your best bet is to do this as a single, bulk operation if possible.That way you can simply do an UPDATE ... WHERE EXISTS followed by an INSERT ... SELECT ... WHERE NOT EXISTS.     hmm, I don't quite understand what you are saying and I think my