Στις Friday 14 January 2011 16:41:18 γράψατε: > Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> wrote: > > > and NOT EXISTS > > (SELECT distinct mold.id from marinerstates > > Does that do better if you leave out the DISTINCT keyword? Maybe > use * instead of the column name? Its already really fast, it doesn't matter. Anyways just tried without the distinct ...NOT EXISTS (SELECT 1 from ... and its the same (high) speed. The other form (NOT IN) is the problem (in the case of postgresql-9.0.2). (in 8.3 both queries are fast) > > -Kevin > -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
