Project

General

Profile

Actions

Idea #14004

open

[Controller] Keep database in tune

Added by Tom Clegg over 5 years ago. Updated about 2 months ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
Performance
Target version:
Start date:
Due date:
Story points:
-
Release:
Release relationship:
Auto

Description

Some postgresql defaults (like autovacuum) are not very suitable for Arvados use patterns. By default Arvados should adjust PostgreSQL tuning parameters according to current table sizes and expected access patterns. A sophisticated operator should still be able to disable automatic tuning and do it manually.


Related issues

Related to Arvados - Bug #13924: Timeout when getting collection by portable data hashResolvedTom Clegg08/20/2018Actions
Related to Arvados - Bug #11556: occasional API server badness: 'incomplete response received from application'NewActions
Related to Arvados - Bug #20990: Need a btree index for postgres to do efficient '=' operations on nameResolvedPeter Amstutz09/25/2023Actions
Actions

Also available in: Atom PDF