RoundSparrowM to

Lemmy Server Performance · 1 year ago

PostgreSQL for Lemmy instance installers/operators/upgraders

2

PostgreSQL for Lemmy instance installers/operators/upgraders

RoundSparrowM to

Lemmy Server Performance · 1 year ago

Diving in, I haven’t worked with PostgreSQL for 15 years, but sharing random notes and obsrervations

Chat

RoundSparrowOPM
link
fedilink
arrow-up
1·
1 year ago
pg_repack is a heavy duty extension for performance optimizaton: https://github.com/reorg/pg_repack

Lemmy Server Performance

lemmyperformance

You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !lemmyperformance@lemmy.ml

Lemmy Server Performance

lemmy_server uses the Diesel ORM that automatically generates SQL statements. There are serious performance problems in June and July 2023 preventing Lemmy from scaling. Topics include caching, PostgreSQL extensions for troubleshooting, Client/Server Code/SQL Data/server operator apps/sever operator API (performance and storage monitoring), etc.

Visibility: Public

This community can be federated to other instances and be posted/commented in by their users.

1 user / day
1 user / week
1 user / month
1 user / 6 months
63 local subscribers
423 subscribers
42 Posts
209 Comments
Modlog