Quoting Raimon Fernandez <co...@montx.com>:
I want to understand why one of my postgresql functions takes an
eternity to finish.
Here's an example:
UPDATE comptes SET belongs_to_compte_id=42009 WHERE (codi_compte LIKE
'10000%' AND empresa_id=2 AND nivell=11); // takes forever to finish
[...]
but the same SELECT count, it's immediate:
SELECT count(id) FROM comptes WHERE codi_compte LIKE '10000%' AND
empresa_id=2 AND nivell=11;
Maybe there is any check or constraint on belongs_to_compte_id.comptes that
might take longer?
Cheers,
-Mike
--
Michał Roszka
m...@if-then-else.pl
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
