Ancestors

Toot

Written by Kuba Suder • @mackuba.eu on 🦋 on 2024-11-11 at 14:55

[#]Postgres people: what's your advice for how I should configure how it uses memory etc.? I think it uses much less than MySQL now (a couple hundred MB) but does way more disk reading, so it could be caching more (this is a 8 GB RAM instance). Right now I have a default unmodified config. #postgresql

=> More informations about this toot | More toots from mackuba@martianbase.net

Descendants

Written by Kuba Suder • @mackuba.eu on 🦋 on 2024-11-11 at 14:59

(Details: ~100-150 GB of data, mostly in one "posts" table (100-200M rows), write-heavy (~50-100 posts/s saved), read load is mostly from "timeline" requests which look up recent posts made by any of the followed users)

=> More informations about this toot | More toots from mackuba@martianbase.net

Written by Miguel Arroz on 2024-11-11 at 15:18

@mackuba It has been a long while and I don't remember details, but usually you want to be very generous with the memory used by the shared cache, since that is what caches indexes. Check the current docs since the last time I did that was like 15 years ago, but usually you don't want PgSQL to use as little memory as possible, but as much as possible. I don't remember the recipes, but the more you use, the better. I think it was even recommended to disable swapping on the DB server.

=> More informations about this toot | More toots from arroz@mastodon.social