Quoting Raimon Fernandez <coder@xxxxxxxxx>:
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 mike@xxxxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
