Shared Memory Buffer Postgresql

user_11414483 0
Viewed 323

A little bit of a background about my status:

I'm currently using OVH Advance 5 Server (AMD Epyc 7451 - 24 c / 48 t - 128 GB Memory - 450x2 GB SSD) and I was wondering the specifications I should be using for Postgresql.

I'll be using multiprocess running 24 Python scripts with 24 different pools (using asynpg to connect), and I usually use up about 40 GB of RAM or so - that means I have around 88 GB to work with.

Before I've never really touched any of the settings for Postgres; what kind of values should I be using for:

Shared Memory / Max Connections / Random Page Cost?

Reading up on it, it says it's recommended that Shared Memory should generally take up about 25% of the free RAM - but other sources say 2 - 4 GB is generally the sweet spot point, so any insight would be greatly appreciated.

asyncpg postgresql python
1 Answers

  • shared_buffers: start with 25% of the available RAM or 8GB, whatever is lower.

    You can run performance tests to see if other settings work better in your case.

  • max_connections: leave the default 100. If you think that you need more than 50 connections, use the connection pooler pgBouncer.

  • random_page_cost: if your storage is as fast with random I/O as with sequential I/O, use a setting of 1.1. Otherwise, stick with the default 4.

user_64643080
Related