>> Only 130 rows out of the 30000 have ARCHIVED = 0 > in this case i would suggest a partial index: > create index <indexname> on <tablename> (archived) where archived = 0; Thanks, Andreas. Sorry for the confusion about the table names. The hint with the partial index sounds as it could solve the problem. I will test it. Regards Jürgen -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
