Tom,
Using something newer than 8.1 would help.
Thank you.If
CREATE TEMP TABLE ids ( id int ) ON COMMIT DROP;is created, ids are added to this table and ids table is used in inner join insted of IN clause or
IN clause is replaced with ... dokumnr IN ( SELECT id FROM ids ) ... , will this fix the issue in 8.1.4 ? Andrus. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
