Re: [GENERAL] Slow query plan used - Mailing list pgsql-general

>> 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