Am 31.05.2017 um 13:27 schrieb Wetzel, Juergen (Juergen):
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.
you are welcome. please keep me informed if that helps you.
Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
