KomuSolutions/igot99issues
3
0
Issues 11 Projects 1 Wiki

Szuru API slow response times #42

New Issue
Closed
opened 2024-06-16 15:08:43 +02:00 by lukas · 1 comment
lukas commented 2024-06-16 15:08:43 +02:00
Owner
Copy Link

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 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
Author
Owner
Copy Link

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 Branch/Tag Specified
Branches Tags
Labels
Clear labels   
Breaking

Breaking change that won't be backward compatible

  
Domain
komu.boo

  
Domain
langrock.info

  
Domain
libre.moe

  
Involves
Documentation
Issue invovles changing the documentation

  
Involves
Security
This is security issue

  
Involves
Testing
Issue or pull request related to testing

  
Kind
Bug
Something is not working

  
Kind
Enhancement
Improve existing functionality

  
Priority
Critical
The priority is critical

  
Priority
High
The priority is high

  
Priority
Low
The priority is low

  
Priority
Medium
The priority is medium

  
Service
Drone

  
Service
Element

  
Service
Gitea

  
Service
Matrix

  
Service
Nextcloud

  
Service
Szuru

  
Status
Abandoned
Somebody has started to work on this but abandoned work

  
Status
Acknowledged
Issue has been confirmed

  
Status
Blocked
Something is blocking this issue or pull request

  
Status
Duplicate
This issue or pull request already exists

  
Status
Invalid
Invalid issue

  
Status
Need More Info
Feedback is required to reproduce issue or to continue work

  
Status
Won't Fix
This issue won't be fixed

No Label
Breaking
Domain
komu.boo
Domain
langrock.info
Domain
libre.moe
Involves
Documentation
Involves
Security
Involves
Testing
Kind
Bug
Kind
Enhancement
Priority
Critical
Priority
High
Priority
Low
Priority
Medium
Service
Drone
Service
Element
Service
Gitea
Service
Matrix
Service
Nextcloud
Service
Szuru
Status
Abandoned
Status
Acknowledged
Status
Blocked
Status
Duplicate
Status
Invalid
Status
Need More Info
Status
Won't Fix
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Issue Board
Assignees
Clear assignees
No Assignees
lukas
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.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?