VACUUM locking for 21 hours and counting

From: Halford Dace <hal(at)stowe(dot)co(dot)za>
To: pgsql-admin(at)postgresql(dot)org
Subject: VACUUM locking for 21 hours and counting
Date: 2003-03-13 06:22:10
Message-ID: Pine.SGI.4.44.0303130818000.54536-100000@jove.stowe.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

context:

PostgreSQL 7.0.3
Database containing one table with ca. 500,000 records. It's vacuumed
nightly, but normally doesn't change much. The table is, arguably,
overindexed, but it took a lot to get acceptable performance on the
queries which it runs.

I delete 120,000 records from the big table.

I run VACUUM.

21 hours later, I'm still waiting for it to finish.

What on earth can I do?

Oh yes, I _did_ run a backup just before doing the DELETE, but would
really rather not have to restore that right now.

Thanks,

Hal

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Halford Dace 2003-03-13 06:53:12 Re: VACUUM locking for 21 hours and counting
Previous Message Tom Lane 2003-03-13 05:58:53 Re: max_connections beyond 47 causes hang