@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 | View the thread | More toots from arroz@mastodon.social
=> View mackuba@martianbase.net profile
text/geminiThis content has been proxied by September (ba2dc).