Project

General

Profile

Actions
Copy link

Idea #14004

open

[Controller] Keep database in tune

Added by Tom Clegg over 6 years ago. Updated 9 months ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
Performance
Target version:
Future
Start date:
Due date:
Story points:
-
Release:
Postponed
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
Copy link
 #1

Updated by Tom Clegg over 6 years ago

  • Related to Bug #13924: Timeout when getting collection by portable data hash added
Actions
Copy link
 #3

Updated by Tom Clegg over 6 years ago

  • Related to Bug #11556: occasional API server badness: 'incomplete response received from application' added
Actions
Copy link
 #7

Updated by Peter Amstutz over 3 years ago

  • Target version deleted (To Be Groomed)
Actions
Copy link
 #8

Updated by Peter Amstutz almost 2 years ago

  • Release set to 60
Actions
Copy link
 #9

Updated by Tom Clegg about 1 year ago

  • Related to Bug #20990: Need a btree index for postgres to do efficient '=' operations on name added
Actions
Copy link
 #10

Updated by Peter Amstutz 9 months ago

  • Target version set to Future
Actions
Copy link

Also available in: Atom PDF