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

Re: Weird error

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Weird error
Date: 2001-06-28 19:03:21
Message-ID: Pine.BSO.4.10.10106281502070.5536-100000@spider.pilosoft.com (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, 28 Jun 2001, Joseph Shraibman wrote:

> Alex Pilosov wrote:
> > 
> 
> > This is definitely FALSE. Vacuum does not lock the database, it acquires
> > certain locks while its vacuuming certain tables. I.E. your clients may
> > not be able to modify table while its being vacuumed.
> > 
> I've had a vacuum deadlock my database.  When I killed the vacuum client
> (^C from the command line) my program  continued.

Are you sure you mean 'deadlock'? Deadlock is when neither client nor
vacuum can proceed. What most likely happened is vacuum locking the table
until its done, and that is a normal behavior.

-alex


In response to

Responses

pgsql-general by date

Next:From: Philip MolterDate: 2001-06-28 19:08:41
Subject: Re: Slower on Solaris (NOT that Red Hat thread anymore)
Previous:From: Vince VielhaberDate: 2001-06-28 19:00:39
Subject: Re: Repeated messages (was Re: Suggested improvement : Adjust SEQUENCES)

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