Re: Weird error - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: Weird error
Date
Msg-id 3B3B7BD6.6FFDB4E@selectacast.net
Whole thread Raw
In response to Re: Weird error  (Alex Pilosov <alex@pilosoft.com>)
Responses Re: Weird error  (Alex Pilosov <alex@pilosoft.com>)
List 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@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com

pgsql-general by date:

Previous
From: Jan Poslusny
Date:
Subject: unicode regular insensitive matching
Next
From: Vince Vielhaber
Date:
Subject: Re: Repeated messages (was Re: Suggested improvement : Adjust SEQUENCES)