=?utf-8?b?TWljaGHFgg==?= Roszka <mike@xxxxxxxxxxxxxxx> writes: > 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? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
