Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> writes:
> We have been having a problem with a long running vacuum on a table
> blocking deletes. We have a log table on which the only activity is an
> on going series of deletions. The problem is experienced on a slony
> replicated node, but I don't think that slony is at fault here.
> My question - why is a vacuum blocking a deletion?
The problem is evidently that it's got an exclusive lock on the table:
> 17578 | 1744920 | AccessExclusiveLock | t
which is entirely unexpected behavior for plain VACUUM in any release
later than 7.1. I have to think that slony does have something to do
with it ... would suggest asking the slony folk about this.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2006-01-04 23:22:59|
|Subject: back-patching locale environment fix|
|Previous:||From: Brad Nicholson||Date: 2006-01-04 21:23:05|
|Subject: Vacuum Blocking A Deleteion - Why?|