On Tue, Aug 8, 2023 at 5:49 PM Marc Millas wrote:
> also,
> checkpoint setup are all default values
>
> you may try to
> checkpoint_completion_target = 0.9
> checkpoint_timeout = 15min
> max_wal_size = 5GB
>
> and, as said in the previous mail, check the checkpoint logs
>
> Also, all vacuum and
also,
checkpoint setup are all default values
you may try to
checkpoint_completion_target = 0.9
checkpoint_timeout = 15min
max_wal_size = 5GB
and, as said in the previous mail, check the checkpoint logs
Also, all vacuum and autovacuum values are defaults
so, as autovacuum_work_mem = -1
the
Hello,
in the postgresql.conf joined, 2 things (at least) look strange:
1) the values for background writer are the default values, fit for a
server with a limited writes throughput.
you may want to increase those, like:
bgwriter_delay = 50ms
bgwriter_lru_maxpages = 400
bgwriter_lru_multiplier =
On 8/7/23 08:41, KK CHN wrote:
List ,
*Description:*
Maintaining a DB Server Postgres and with a lot of read writes to this
Server( virtual machine running on ESXi 7 with CentOS 7) .
( I am not sure how to get the read / write counts or required IOPS or any
other parameters for you. If
List ,
*Description:*
Maintaining a DB Server Postgres and with a lot of read writes to this
Server( virtual machine running on ESXi 7 with CentOS 7) .
( I am not sure how to get the read / write counts or required IOPS or any
other parameters for you. If you point our I can execute those