Szuru API slow response times #42

New Issue

lukas · 2024-06-16T15:08:43+02:00

lukas commented

2024-06-16 15:08:43 +02:00

Various API endpoints take very long to respond. This makes the UI feel extremely slow, as loading times of ~2s are required for viewing a post or even just liking it.
On the server-side postgres jumps to 100% (single core) for the entire duration, so something is either wrong with the query, the db or postgres.

This issue existed before but was magically fixed recently. After moving from postgres 13 to 16 (#40), the issue now reappeared.

Various API endpoints take very long to respond. This makes the UI feel extremely slow, as loading times of ~2s are required for viewing a post or even just liking it. On the server-side postgres jumps to 100% (single core) for the entire duration, so something is either wrong with the query, the db or postgres. This issue existed before but was magically fixed recently. After moving from postgres 13 to 16 (#40), the issue now reappeared.

lukas added the

labels 2024-06-16 15:08:44 +02:00

lukas self-assigned this 2024-06-16 15:08:44 +02:00

lukas added this to the Issue Board project 2024-06-16 15:08:44 +02:00

lukas commented

2024-06-16 15:21:50 +02:00

Soooo... it seems like Postgres was the culprit. After looking through the migration log I found a note about running vacuumdb to optimize the db and well, that worked.

Soooo... it seems like Postgres was the culprit. After looking through the [migration log](https://git.libre.moe/KomuSolutions/igot99issues/issues/40#issuecomment-2687) I found a note about running `vacuumdb` to optimize the db and well, that worked.

lukas closed this issue

2024-06-16 15:21:50 +02:00

lukas removed the

Status

Planned

label 2024-06-16 15:23:09 +02:00

lukas removed this from the Issue Board project 2024-12-17 12:28:01 +01:00

Sign in to join this conversation.