Table schema for the column version of RLS performant applications.

rls-performance-column-table.sql

create table if not exists items (
  id uuid default uuid_generate_v4() not null primary key,
  value text,
  acl_read uuid[] default array[]::uuid[],
  acl_write uuid[] default array[]::uuid[]
);
-- e.g. ('f386...5e99', 'I row and therefore I am', {'eac6...f6c9'}, {'0fdc...947f'})

create index read_permissions_index on items using gin(acl_read);
create index write_permissions_index on items using gin(acl_write);