nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Experience with Jira Performance of Postgres 10/11 compared with Postgres 9.6

Jens Kisters __SeibertSolutions

Hello everyone,

has anyone upgraded to the newer Postgres versions that have recently been added as supported versions and noticed a measurable effect on the performance?

Thanks in advance

Jens

Accepted answers

All comments

Gonchik Tsymzhitov

Hi!

Could you provide a more info about your instance?

Jens Kisters __SeibertSolutions

Sure, The instance runs on a dedicated virtual server with 6 CPU cores and 30GB Ram.
The database server and the jira server are running on the same machine.

Jira has been assigned about 12GB but is not really using all the memory.

The instance has a lot of customizing and quite a number of apps and is used on a daily basis by 60 users.

The OS is Ubuntu 18.04

If you need any more details, i'll be happy to provide them on request.

Gonchik Tsymzhitov

What about info from postgresql.conf `and it will be good to know about database pool?

Jens Kisters __SeibertSolutions

We didnt do any tuning the PSQL server is running on a default configuration, the Jira connection pool is on a standard size of 20 as we never ran low on connections so far.

I am thinking before we go into optimizing the buffer sizes etc we decide on which PSQL version we want to run.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

performance

postgres