---
title: Settle the league_data_view_reader role cap
type: task
status: planned
description: >-
  The planned work_mem and parallel-worker role defaults on league_data_view_reader contain nothing
  because data-view statements override both per statement; confirm what is set and reset it as
  housekeeping.
base_uri: user:task/league/settle-data-view-reader-role-cap.md
created_at: '2026-10-10T03:41:30.234Z'
entity_id: a1fc173f-941b-4c67-87f6-b0f256418c07
owner_identity_uri: █████████████████████████
priority: Low
public_read: true
relations:
  - relates [[████████████████████████-██████-██████████]]
  - relates [[█████████████████████-██████████████-████-████-███████████-███████████]]
tags:
  - user:tag/league-xo-football.md
updated_at: '2026-10-10T03:41:30.234Z'
visibility_analyzed_at: '2026-11-05T23:50:23.594Z'
---

# Settle the league_data_view_reader role cap

Split from [[████████████████████████-██████-██████████]]. The migration planned a role default of `work_mem = '64MB'` and `max_parallel_workers_per_gather = 0` on `league_data_view_reader` as containment. It no longer contains anything. Data-view statements set `work_mem` per statement, and league `8f8b961ac` sets `max_parallel_workers_per_gather` per statement on flagged shapes, so both override a role default.

The gate that held this item is gone: [[█████████████████████-██████████████-████-████-███████████-███████████]] is Completed.

## Plan

- [ ] Read the role's current settings on the primary and the replica: `SELECT * FROM pg_db_role_setting` joined to `pg_roles` for `league_data_view_reader`.
- [ ] If a cap is set, drop it with `ALTER ROLE league_data_view_reader RESET ...`. If none is set, record that and do not add one. Record this as housekeeping, not containment.
- [ ] *Verify:* `pg_db_role_setting` shows no row for the role, and one data-view request still runs.