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

2021-09-27 Thread Kim Johan Andersson
'Ole', and that looks fine. So why 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 TABL

Query slow for new participants

2019-02-25 Thread Kim
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, descripti