Skip to content

Instantly share code, notes, and snippets.

@mccun934

mccun934/add temp tasks index

Created October 24, 2016 04:02
Show Gist options
  • Save mccun934/cd4c0d6e06ea57fc525d9d0aaf35a18c to your computer and use it in GitHub Desktop.
Save mccun934/cd4c0d6e06ea57fc525d9d0aaf35a18c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
add temp tasks index
# sudo -u postgres psql -d foreman
psql (9.2.15)
Type "help" for help.
foreman=# create index foreman_tasks_tasks_state_temp_idx on foreman_tasks_tasks ((state <> 'stopped'));
CREATE INDEX
foreman=# analyze;
ANALYZE
foreman=#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment