Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT is immediate but the UPDATE takes forever - Mailing list pgsql-general

From Tom Lane
Subject Re: SELECT is immediate but the UPDATE takes forever
Date
Msg-id 22559.1291736260@sss.pgh.pa.us
Whole thread Raw
In response to Re: SELECT is immediate but the UPDATE takes forever  (Michał Roszka <mike@if-then-else.pl>)
Responses Re: SELECT is immediate but the UPDATE takes forever  (Raimon Fernandez <coder@montx.com>)
List pgsql-general
Tree view 
=?utf-8?b?TWljaGHFgg==?= Roszka <mike@if-then-else.pl> writes:
> Quoting Raimon Fernandez <coder@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

pgsql-general by date:

Previous
From: Kobi Biton
Date:
Subject: Re: if-clause to an exiting statement
Next
From: Raimon Fernandez
Date:
Subject: Re: SELECT is immediate but the UPDATE takes forever