From: | marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: lock problem |
Date: | 2005-09-01 17:02:48 |
Message-ID: | 20050901170248.41443.qmail@web32601.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--- Richard Huxton <dev(at)archonet(dot)com> escribió:
> marcelo Cortez wrote:
> > Hi Richard , folks
> >
> > the query is:
> >
> > SELECT c.actuacion_car AS c_actuacion,
> > c.comentario1 || ' ' || c.comentario2 || ' ' ||
> > c.comentario3 AS c_comentario
> > FROM caratult AS c INNER JOIN extractt AS t1 ON
> ...etc
>
>
> I'm not seeing anything here that should take locks,
> although it's late
> where I am.
>
> > without table definition etc, you see are selects
> > only.
> > during this query, select * from
> pg_catalog.pg_locks
> > show many rows with exclusive locks , and other
> > activities or user's be freezed,
>
> Are you *sure* that it's this query? Could you show
> some of the rows
> from pg_locks along with corresponding rows from
> pg_stat_activity?
>
> --
> Richard Huxton
> Archonet Ltd
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map
> settings
>
__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-01 17:11:58 | Re: Transaction error |
Previous Message | Sebastian Hennebrueder | 2005-09-01 17:00:34 | Re: Exception in Query when mixing explicit join and implicit |