=?utf-8?b?TWljaGHFgg==?= Roszka <m...@if-then-else.pl> writes:
> Quoting Raimon Fernandez <co...@montx.com>:
>> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
