Vacuum deadlocks?

From: eric soroos <eric-psql(at)soroos(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Vacuum deadlocks?
Date: 2003-01-10 17:05:20
Message-ID: 124581471.1169932976@[4.42.179.151]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I've got a reasonably busy system that logically needs vacuum on a better than daily basis, at least in a couple of the tables. There are times when the traffic is lower, but they're not necessarily predictably overnight, as there are some long running processes that people like to start as they leave in the afternoon.

I'm running 7.2.1 on OSX 10.1.5 (dual 800, 768 megs of memory, the machine is serving as app/db/webserver) using Mark Liange's package from entropy.ch. an upgrade is planned, but he doesn't have newer packages for < 10.2, and I'm not planning to upgrade to 10.2 on this machine quite yet.

Every so often (perhaps 1 time in 50) the vacuumdb -a --analyze command will deadlock the system, so that the clients show a status of either 'starting' or 'async-notify', or 'idle in transaction'. This happened roughly every other day when I had vacuum running from an hourly cron, once a week from the every 3 hour cron, and now it's happened a couple of times when I run it just after backups.

What am I doing wrong here? Is this a known issue for older versions? Or should I be running the vacuums in a different manner?

eric

What am I doing wrong here?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-01-10 17:23:45 Re: Vacuum deadlocks?
Previous Message Tom Lane 2003-01-10 04:50:54 Re: How to list schemas and table in psql?