Re: Waiting for select - Mailing list pgsql-general

From Marc Munro
Subject Re: Waiting for select
Date
Msg-id 1118444359.13526.8.camel@bloodnok.com
Whole thread Raw
In response to Re: Waiting for select  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
It's doing something in slony.  Part of the initial sync operation I
guess.  I guess it must be doing an alter table or reindex or something.
I don't understand why though.

I'll repeat my question on the slony mailing list.  Thanks for the
response.

__
Marc

On Fri, 2005-06-10 at 18:48 -0400, Tom Lane wrote:
> Marc Munro <marc@bloodnok.com> writes:
> > Can someone explain this?  I seem to have a query which is being blocked
> > by a lock.  I was under the impression that selects are never blocked.
>
> AccessExclusiveLock blocks anything.
>
> > A query of blocking locks shows this:
>
> >           object           | trans | pid  |        mode         | blocker
> > ---------------------------+-------+------+---------------------+---------
> >  testdb.address_type       |       | 5754 | AccessExclusiveLock |
> >  testdb.address_type       |       | 5987 | AccessShareLock     |    5754
>
> So what's process 5754 doing?
>
>             regards, tom lane

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Waiting for select
Next
From: Karsten Hilbert
Date:
Subject: Re: Version Control?