Quoting Raimon Fernandez <[email protected]>:
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
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
