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
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
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!
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