=?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
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2007-06-13 18:15:20|
|Subject: Re: Update table performance problem |
|Previous:||From: Mark Makarowsky||Date: 2007-06-13 17:13:50|
|Subject: Update table performance problem|