On 7dic, 2010, at 16:37 , Tom Lane wrote: >> Quoting Raimon Fernandez <coder@xxxxxxxxx>: >>> I want to understand why one of my postgresql functions takes an >>> eternity to finish. > >> Maybe there is any check or constraint on belongs_to_compte_id.comptes that >> might take longer? > > Or maybe the UPDATE is blocked on a lock ... did you look into > pg_stat_activity or pg_locks to check? no, there's no lock, blocked, ... I'm the only user connected with my developer test database and I'm sure there are no locks, and more sure after looking at pg_locks :-) thanks, r. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
