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

Postgres 7.4.2 hanging when vacuum full is run

From: "Radhika S" <radhika(dot)sambamurti(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Postgres 7.4.2 hanging when vacuum full is run
Date: 2007-09-28 14:28:03
Message-ID: fe27bfd40709280728m21c6b02fr4eb91655df021687@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi -

This has been happening more recently. Our database  hangs after a VACUUM
and is unresponsive when we come in next morning.

The vacuum job runs at 03:00 am daily.
The command is : /usr/local/pgsql/bin/vacuumdb --full -d DbName

Also, what exactly does this mean VACUUM waiting. Is there a reason why it
is never emerging from the VACUUM job?
I understand that doing a vacuumdb --full causes the tables to lock (not
really sure about the workings of vacuum).

Any light on this would be really appreciated.

Thanks,
Radhika


Below is what ps -ef |grep postgres shows:

 5530 ?        S      0:13 /usr/local/pgsql/bin/postmaster -i
     5534 ?        S      0:01 postgres: stats buffer process
     5535 ?        S      0:04 postgres: stats collector process
     5621 ?        S      0:53 postgres: slony myDB 10.142.20.50 idle
     5626 ?        S      0:51 postgres: slony myDB 10.142.20.50 idle
     5627 ?        S      0:34 postgres: slony myDB 10.142.20.50 idle
     5628 ?        S      5:40 postgres: slony myDB 10.142.20.50 idle
     5637 ?        S      2:09 postgres: slony myDB 10.132.20.26 idle
     5638 ?        S      1:56 postgres: slony myDB 10.132.20.26 idle
     5745 ?        S     42:08 postgres: abc myDB [local] idle
    20774 ?        S      4:29 postgres: abc myDB [local] idle
    20775 ?        S      0:00 postgres: abc myDB [local] idle in
transaction
    20776 ?        S      0:00 postgres: abc myDB [local] idle
    17509 ?        S      0:06 postgres: abc myDB [local] VACUUM waiting
    24656 ?        S      0:00 postgres: abc myDB [local] INSERT waiting
    30489 ?        S      0:00 postgres: abc myDB [local] SELECT waiting
    30637 ?        S      0:00 postgres: abc myDB [local] UPDATE waiting
    30647 ?        S      0:00 postgres: abc myDB [local] UPDATE waiting
    30668 ?        S      0:00 postgres: abc myDB [local] UPDATE waiting


-- 
It is all a matter of perspective. You choose your view by choosing where to
stand. --Larry Wall

Responses

pgsql-performance by date

Next:From: Richard HuxtonDate: 2007-09-28 14:43:41
Subject: Re: sequence query performance issues
Previous:From: Tom LaneDate: 2007-09-28 14:16:19
Subject: Re: sequence query performance issues

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