Partial index on enum type is not being used, type issue?

is the varchar version not using the index? Any thoughs on this? Regards, Kim Johan Andersson SELECT version(); CREATE TYPE type_table_test_enum AS ENUM ( 'Ole', 'Bole', 'Skole' ); CREATE TABLE table_test_enum ( val type_table_test_enum NOT NULL, dat date ); CREATE UNIQUE

Query slow for new participants

Hello, I have an article query which returns articles enabled for a participant. Article table – Participant table – Table in between which stores the links between the Article and particitpant including characteristics such as enabled. It is possible to search on the articles by number,