=?iso-8859-1?Q?RESTOUX=2C_Lo=EFc?= <loic(dot)restoux(at)capgemini(dot)com> writes:
> Since some weeks, the amount of data hosted by the database grows, and, som=
> e nights, the database vacuum seems to "freeze" during his execution. In v=
> erbose mode, the logs show that the vacuum clean up a table (not always the=
> same table), and... no more news. The system shows a vacuum process, which=
> seems to be sleeping (no CPU used, no memory consumption...).
Have you looked into pg_locks to see if it's blocked on someone else's lock?
regards, tom lane