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

Re: Weird error

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Alex Pilosov <alex(at)pilosoft(dot)com>
Cc: Alex Knight <knight(at)phunc(dot)com>, Philip Molter <philip(at)datafoundry(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Weird error
Date: 2001-06-28 18:47:50
Message-ID: 3B3B7BD6.6FFDB4E@selectacast.net (view raw or flat)
Thread:
Lists: pgsql-general
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.


-- 
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio.  http://www.targabot.com

In response to

Responses

pgsql-general by date

Next:From: Vince VielhaberDate: 2001-06-28 19:00:39
Subject: Re: Repeated messages (was Re: Suggested improvement : Adjust SEQUENCES)
Previous:From: Jan PoslusnyDate: 2001-06-28 18:41:04
Subject: unicode regular insensitive matching

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