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.
In response to
pgsql-general by date
|Next:||From: Philip Molter||Date: 2001-06-28 19:08:41|
|Subject: Re: Slower on Solaris (NOT that Red Hat thread anymore)|
|Previous:||From: Vince Vielhaber||Date: 2001-06-28 19:00:39|
|Subject: Re: Repeated messages (was Re: Suggested improvement :