Open bwbroersma opened 7 months ago
Currently the PostgreSQL container is in default configuration.
A list to tune/monitor:
log_min_duration_statement
track_io_timing
shared_buffers
work_mem
Currently the PostgreSQL container is in default configuration.
A list to tune/monitor:
log_min_duration_statementfor monitoringtrack_io_timingfor monitoring (although got better in pg16?) - the perfomance impact is probably very low (see Getting the most out of pg_stat_io talk on 2023 pgconfeu).shared_buffersbased on server (e.g. at least ×2-4)work_mem(e.g. at least ×2-3), set it higher for the Hall of Fame (hof) call (since now temp files are used)