=?iso-8859-1?Q?RESTOUX=2C_Lo=EFc?= <loic.restoux@xxxxxxxxxxxxx> 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
