=?utf-8?b?TWljaGHFgg==?= Roszka <[email protected]> writes:
> Quoting Raimon Fernandez <[email protected]>:
>> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general