Szuru API slow response times #42

Closed
opened 2024-06-16 15:08:43 +02:00 by lukas · 1 comment
Owner

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
Kind
Bug
Priority
Medium
Status
Acknowledged
Service
Szuru
Domain
LibreMoe
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
Author
Owner

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
Acknowledged
label 2024-06-16 15:23:09 +02:00
Sign in to join this conversation.
No Milestone
No project
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: KomuSolutions/igot99issues#42
No description provided.