Single post
jump to replies
Using #gotosocial + #postgresql for a small instance (25 to 50 users) on a small server (intel N2800/4Gb/SSD). A good idea? Any feedbacks?
8 visible replies; 5 more replies hidden or not public
back to top
@adele Didn't test it, but does not sound far off, i'd give it a try!
@adele Well, I don't know, I only use a server for one user. But I use sqlite. It suits me just fine.
I think it would work just as well for a small number of users.
But at the same time, postgres is very good. I just don't want to set up a separate service for this.
@adele ? I run it w/ sqlite on a N100 at home ...
@adele I'd say it's unnecessary. Adding the weight of a postgresql server seems excessive
@adele
maybe ask in the matrix group as well?
https://matrix.to/#/%23gotosocial-space:superseriousbusiness.org
@adele I'm running a (currently) single user GoToSocial instance with Postgres.
Switched from sqlite because it was frequently throwing errors, and I didn't want to debug and tune sqlite.
Postgres Just Works. An added advantage is that with it, I could move the db server to a different machine.
@adele I'd stick to SQLite personally. goblin.technology runs on SQLite with about 30 users, 1GB ram (with swap), and 1 CPU, and performance is totally fine. There's not much reason to add the overhead of Postgres unless you need to run it anyway for some other service you have deployed, and you want stuff in one place.
@adele More than enough. I got it running on a Raspberry Pi Zero 2 with 512MB ram :)