this post was submitted on 08 Jun 2023
46 points (100.0% liked)

Lemmy.World Announcements

29165 readers
33 users here now

This Community is intended for posts about the Lemmy.world server by the admins.

Follow us for server news ๐Ÿ˜

Outages ๐Ÿ”ฅ

https://status.lemmy.world

For support with issues at Lemmy.world, go to the Lemmy.world Support community.

Support e-mail

Any support requests are best sent to [email protected] e-mail.

Report contact

Donations ๐Ÿ’—

If you would like to make a donation to support the cost of running this platform, please do so at the following donation URLs.

If you can, please use / switch to Ko-Fi, it has the lowest fees for us

Ko-Fi (Donate)

Bunq (Donate)

Open Collective backers and sponsors

Patreon

Join the team

founded 2 years ago
MODERATORS
46
submitted 2 years ago* (last edited 2 years ago) by ruud to c/lemmyworld
 

I'm not happy with the performance, especially when clicking 'Post' it takes too long.

First I will upgrade this VPS from 2cpu/4GB to 4cpu/16GB.

Then I will tune the database (more shared_buffers to start with)

After that I'll see what more I can tune, together with the Lemmy admin channel.

top 11 comments
sorted by: hot top controversial new old
[โ€“] ruud 17 points 2 years ago (1 children)

Server is rescaled. Still not 100% happy with performance, but we can check further from here. More room for tuning anyway.

[โ€“] PM_ME_YOUR_BOOBIES 1 points 2 years ago (1 children)

Was there an improvement at least?

[โ€“] ruud 2 points 2 years ago (1 children)

At least there now are resources to be used, if I can get the software to use it ...

[โ€“] [email protected] 8 points 2 years ago

Thank you for your work!

[โ€“] Weerdo 6 points 2 years ago (1 children)

Given the influx of users, and the general scramble with server restarts, it feels like the early day of forums again. I'll not be complaining about it!

[โ€“] CannaVet 5 points 2 years ago

Yeah it really takes you back lmfao, I think it's great that people are starting to see the benefits of decentralization again, I had started flirting with self hosting last year and have like 20+ docker containers running on a pi 4 now.

[โ€“] veroxii 6 points 2 years ago (1 children)

Let me know if you need some advice. I've been helping the Lemmy devs with their db queries on GitHub. They should release a new version soon which will help a bit. And I gave some more advice today.

You seem to know what you're doing on the infra side but if you need someone to review pg settings and tuning I'm happy to help. I'm not sure how you installed this instance but I'd recommend pumping up the db connections from default and using a connection pooler like pgbouncer if you're not already.

[โ€“] ruud 7 points 2 years ago

Thanks for the offer! The database side is the side I'm most familiar with (I'm a (Postgres) DBA), but any help is appreciated at this moment because there's a lot to do with this crazy inflow of users!

[โ€“] BackOnMyBS 4 points 2 years ago

I appreciate your hard work!

[โ€“] Loki 4 points 2 years ago

I'm impressed by this community already