On 7 Dec 2010, at 15:45, Michał Roszka wrote: >> 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?
Or a foreign key constraint or an update trigger, to name a few other possibilities. Alban Hertroys -- Screwing up is an excellent way to attach something to the ceiling. !DSPAM:737,4cfe7af5802659106873227! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
