Running an undisruptive pg_repack (no kill backend) on the database after 7 years, postgres performance has been deteriorating resulting in longer queues, especially visible on linkcrawling (previews missing), will check for other options if this doesn't improve the situation.
Conversation
Notices
-
Embed this notice
SolSoCoG (solsocog@ieji.de)'s status on Saturday, 08-Nov-2025 23:40:43 JST
SolSoCoG
-
Embed this notice
Sexybiggetje🐖 (martijn@ieji.de)'s status on Sunday, 09-Nov-2025 00:01:46 JST
Sexybiggetje🐖
@SolSoCoG already running pgbouncer?
-
Embed this notice
SolSoCoG (solsocog@ieji.de)'s status on Sunday, 09-Nov-2025 00:03:18 JST
SolSoCoG
@martijn last time I used that I've seen almost zero palpable improvement so when migrating to the 7950x3d machines i skipped using it, maybe i was wrong :schmusekadser:
-
Embed this notice
Alex (alex02@ieji.de)'s status on Sunday, 09-Nov-2025 01:42:46 JST
Alex
-
Embed this notice