Questions regarding the "200,000 issues limitation" of JIRA

Daisuke Niwa

Hi there,

It is often said that it's not recommended to have more than 200,000 issues on one JIRA instance.

Regarding this, we've got following questions.

1) Does this mean that JIRA's performance goes down dramatically once you get more than 200,000 issues on one JIRA instance?

2) Is it possible to make JIRA more scalable by switching database? Right now we are using PostgreSQL and does it work if we change it to, say, Oracle?

Please advise.

Regards,

Daisuke Niwa

JamieA

The official quote is 200k - 300k, but it's never backed up by any explanation of where the bottleneck is. You should take it with a pinch of salt, many sites including mine have way more than that, although you need to tune often.

IMHO you won't get any benefit from switching to oracle, probably the opposite.