Re: lazy vacuum and AccessExclusiveLock

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Jaromír Talíř <jaromir(dot)talir(at)nic(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: lazy vacuum and AccessExclusiveLock
Date: 2009-09-24 18:41:19
Message-ID: 20090924184119.GB3914@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jaromír Talíř wrote:

> we are facing strange situation with exclusively locked table during
> normal lazy vacuum. There is one big table (66GB) that is heavily
> inserted and updated in our database. Suddenly (after backup and delete
> of almost all records) we are not able to run VACUUM over this table
> because after 50 minutes of work it allocate AccessExclusiveLock on this
> table and all other connections start to timeout.

What version are you running?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ricky Tompu Breaky 2009-09-24 18:47:03 Newbie's question: How can I connect to my postgresql-server?
Previous Message Reid Thompson 2009-09-24 18:02:59 Partitioned table question