[GENERAL] Can't get planner to use multicolumn index on large table

Hi! I am trying to get postgres to use my index but it just doesn't. Please Help! It follows the table definition and a series of commands I thought would ensure usage of my index. CREATE TABLE data.question_result ( id bigserial PRIMARY KEY, trial_idbigint

[GENERAL] Howto handle views/Rules Privileges

Hi! Situation two schemas: webviews: Contains a set of views with insert rules on them, accessed via a GUI. devconf: "Business logic", all the tables, functions, triggers that I want to restrict access to as far as possible.Preferably, I wouldn't even grant usage to the schema. I have a problem