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