Hi Álvaro,
Pardon my stupidity. I kept looking for things in the wrong place. The
pg_toast tables have always been there, I was just issuing the commands yo
mentioned in a different database. Need to get more sleep. xD
In the end, we decided the entire database needed a good cleaning. So we
sched
Hi Erik,
I thouht pg_cancel_backend and pg_terminate_backend simply send SIGINT and
SIGTERM, respectively, to the backend process? We did try using the commands
and sending the signals ourselves, but to no avail.
--
View this message in context:
http://postgresql.nabble.com/postgresql-9-3-5-au
Hi everyone,
Two weeks ago, one of our Postgres databases crashed violently and had to be
brought up again. This certainly resulted in some lost pg_clog files, and we
had to zero-fill them in one by one to get autovacuum up and running again.
Now, we have two autovacuuming processes constantly st
