Problems with vacuumdb

From: "Ignacio Colmenero" <ignacio(dot)colmenero(at)micotan(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Problems with vacuumdb
Date: 2005-09-19 19:00:51
Message-ID: 20050919190053.1DB46BBC004@whelby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.

I am receiving the following message when I do the vacuumdb process on a
production database:

INFO: vacuuming "pg_catalog.pg_largeobject"

INFO: index "pg_largeobject_loid_pn_index" now contains 4828104 row
versions in 37078 pages

DETAIL: 278 index row versions were removed.

116 index pages have been deleted, 116 are currently reusable.

CPU 0.52s/1.23u sec elapsed 225.77 sec.

vacuumdb: vacuuming of database "log" failed: ERROR: canceling query due to
user request

It seems to me that the process performs successfully a reindex of
pg_largeobject_loid_pn_index, but it doesn't finish the vacuuming of
pg_largeobject.

I'm running PostgreSQL 8.0.3 on Debian GNU/Linux. The command I am using is:

/usr/local/pgsql/bin/vacuumdb -d -e -v log >/home/pgsql/vacuum_log.log

Is there anything you would suggest, in order for the vacuum process to get
through? Any parameters I should fix?

Thanks in advance,

-----------------------------------------------

Ignacio Colmenero

Software Development

Micotan Software Company Ltd.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-09-19 19:47:07 Re: character varying == text?
Previous Message Belinda M. Giardine 2005-09-19 18:27:46 running vacuum in scripts