Project

General

Profile

Actions

Task #4301

closed

Optimize PostgreSQL database on both mentat-alt and mentat-dev servers

Added by Jan Mach about 3 years ago. Updated almost 3 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
Category:
Installation
Target version:
Start date:
09/11/2018
Due date:
% Done:

100%

Estimated time:
To be discussed:

Description

I would like to ask our database specialist to optimize PostgreSQL databases both on our testing and development servers (mentat-alt and mentat-dev). Although they are not production level services, it is useful to have them optimized as well so that they do not unnecessarily slow down the host system and developers. Additionally since they are both different systems, their configuration could be incorporated into our documentation to serve as another examples for different host server configurations.

Actions #1

Updated by Pavel Kácha almost 3 years ago

  • Priority changed from Low to High

Pretty please

Actions #2

Updated by Radko Krkoš almost 3 years ago

  • % Done changed from 0 to 30

ACK on priority change

Actions #3

Updated by Radko Krkoš almost 3 years ago

  • % Done changed from 30 to 70

This got sidetracked to develop #4363 which has quite a performance impact, but progressing nicely. First round of configuration done, will be tested over the weekend.

Actions #4

Updated by Jan Mach almost 3 years ago

  • Target version changed from 2.1 to 2.2
Actions #5

Updated by Pavel Kácha almost 3 years ago

How's this going? As far s I know (#4382), PQs are upgraded. Would be nice to have the result in docs (in repo) and close this.

Actions #6

Updated by Radko Krkoš almost 3 years ago

  • Priority changed from High to Urgent

A typical pitfall surfaced here of optimization being a never-ending process. I agree that it is time to wrap this up, document the lessons learned and move on. Increasing priority (both literally and mentally).

Actions #7

Updated by Jan Mach almost 3 years ago

  • Status changed from New to Closed
  • % Done changed from 70 to 100

I consider this issue to be resolved, closing.

Actions

Also available in: Atom PDF