Skip site navigation (1) Skip section navigation (2)

Re: [PG 8.1.0 / AIX 5.3] Vacuum processes freezing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: RESTOUX, Loïc <loic(dot)restoux(at)capgemini(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
Date: 2007-06-13 18:06:28
Message-ID: 14786.1181757988@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
=?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

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2007-06-13 18:15:20
Subject: Re: Update table performance problem
Previous:From: Mark MakarowskyDate: 2007-06-13 17:13:50
Subject: Update table performance problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group