Re: [GENERAL] vacuum won't even start

Tom Lane a écrit : Jean-Christophe Praud writes: Indeed, the tables I tried to vacuum have locks on them. AccessShareLock belonging to queries which seem sleeping. I tried to kill these queries but pg_cancel_backend() has no effect, and the process doesn't get the 15 s

Re: [GENERAL] vacuum won't even start

Tom Lane a écrit : Jean-Christophe Praud writes: I've a problem on a heavy loaded database: vacuums don't work since about a week. All I got is: mybase=# vacuum verbose analyze public.mytable; INFO: vacuuming "public.mytable" (I stop it after hours)

Re: [GENERAL] vacuum won't even start

Alvaro Herrera a écrit : Jean-Christophe Praud wrote: Hi all, I've a problem on a heavy loaded database: vacuums don't work since about a week. All I got is: mybase=# vacuum verbose analyze public.mytable; INFO: vacuuming "public.mytable" (I stop it after hours)

[GENERAL] vacuum won't even start

Hi all, I've a problem on a heavy loaded database: vacuums don't work since about a week. All I got is: mybase=# vacuum verbose analyze public.mytable; INFO: vacuuming "public.mytable" (I stop it after hours) Looking with top and iotop, I see the process takes some cpu and disk io time duri

[GENERAL] Asynchronous trigger

order not to block the client application during the recursive process ? Regards, -- Jean-Christophe Praud - http://shub-niggurath.com Conseil & Développement Informatique http://www.praud.com Ph'nglui mglw'nafh Cthulhu n'gah Bill