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

[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.

[Gonchik Tsymzhitov]

So, it's not bit deal on which version you're running as your instance based on provided info

[Jens Kisters __SeibertSolutions]

Because the instance is too small for the PSQL version to make a difference?

[Gonchik Tsymzhitov]

Here I would say, 

latest is greatest. 

One of info will help you

https://www.postgresql.org/about/featurematrix/#performance