Ah, see, I didn't know that.
On Wed, Nov 20, 2024 at 11:10 PM David Mullineux wrote:
> i dont get why you think all memroy will be used.
> When you say
> shared_buffers = 16GB
> effective_cache_size = 48GB
>
> ...then this is using only 16GB for shared buffers.
>
> The effective _cache_size doe
i dont get why you think all memroy will be used.
When you say
shared_buffers = 16GB
effective_cache_size = 48GB
...then this is using only 16GB for shared buffers.
The effective _cache_size doesn't cause any memory to.be allocated. It's
just a hint to optomizer
On Wed, 20 Nov 2024, 11:16
Assuming a machine with:
* 16 CPU cores
* 64GB RAM
Set to 500 max connections
A tool like this: https://pgtune.leopard.in.ua/
Will output recommended settings:
max_connections = 500
shared_buffers = 16GB
effective_cache_size = 48GB
maintenance_work_mem = 2GB
checkpoint_completion_target = 0.9
