postgresql.conf.bak

listen_addresses = '*'
port = 5400

# Memory
# https://pgtune.leopard.in.ua/
shared_buffers = 65MB
effective_cache_size = 195MB
maintenance_work_mem = 16640kB
wal_buffers = 1996kB
default_statistics_target = 100
random_page_cost = 1.1
work_mem = 110kB
min_wal_size = 2GB
max_wal_size = 8GB

# Checkpoints
checkpoint_completion_target = 0.9 

fsync = off
full_page_writes = off
row_security = off

# Write Ahead Log
synchronous_commit = off          # Can reduce latency at the risk of losing transactions in the event of a crash
wal_writer_delay = '10ms'         # Lower delay can help with more frequent disk flushes for low latency
max_wal_senders = 0
wal_sender_timeout = 0
wal_level = minimal
             

# Planner
random_page_cost = 1.1            # Set lower if using SSDs to reflect their faster random access
effective_io_concurrency = 1      # Increase if your storage supports multiple concurrent I/O operations

# Lock Management
deadlock_timeout = '500ms'        # Reduce the time to detect deadlock situations
max_locks_per_transaction = 64    # Adjust based on your application's locking requirements

# Logging

log_min_duration_statement = '10s' 
log_checkpoints = off               
log_statement = 'none'
log_error_verbosity = terse
log_min_messages = panic
logging_collector = off
log_directory = '/dev/null'
log_min_error_statement = panic
client_min_messages = error
debug_pretty_print = off

# Autovacuum
autovacuum = off                    # Enable autovacuum for automatic maintenance