Recommendations for PostgreSQL or other tuning on a self-hosted instance

Troubleshooting
1

Hi,

I’m self-hosting Taiga, and one of my projects has a lot of stories..

I noticed after importing about 2300 stories that the Kanban board is quite slower than it used to be. It takes something in the order of 8 to 11 seconds to load /api/v1/userstories endpoint.

I’m running Taiga via the standard docker compose, and was curious if anyone has ever had to tweak the postgres or gunicorn configurations to get it to run faster?

I’ve already run ANALYZE; on the database directly in a psql terminal, but I’m not really sure if it’s made a difference.

I’d be interested to hear any insight into what the tree.taiga.io hosted version uses (I imagine it has to deal with performance a lot given it’s a multi-tenant system), though I appreciate you probably can’t give too much away..

Thanks in advance

2

I’d also be interested to know what version of PostgreSQL I could safely run Taiga on. I note the Docker compose comes with postgres:12 which is a bit old - if I upgraded to postgres:14, would Taiga/Django still work ok?

I’m just trying to work out if I stand to get performance improvements on a newer Postgres version as well.

3

Hi there!

It should be compatible with psql 15.

Please do check Migrate Taiga Docker from Postgresql-12 to Postgresql-14 on how to migrate the docker installation (the guide is for docker 14, but it should work regardless).

In any case, you should make a backup before just in case.

Best!