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
s.postgresql.org>
Subject: Re: Memory settings
Try run postgresqltuner.pl<http://postgresqltuner.pl> as suggested on
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and also look at
the other info there.
After running a few days with live data run cache_hit_rat
Try run postgresqltuner.pl as suggested on
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server and also
look at the other info there.
After running a few days with live data run cache_hit_ratio.sql by Melvin
Davidson:
SELECT pg_stat_database.datname,
pg_stat_database.blks_read,
