Your settings are interesting, I'm curious what the goal is for this particular hammerdb exercise. A few comments inline On 10/12/21 00:35, Ashkil Dighin wrote: > > Postgres.conf used in Baremetal > ======================== > maintenance_work_mem = 512MB only a half GB memory for autovac? (it will have a mandatory run as soon as you hit 200 mil XIDs, seems like you'd want the full max 1GB for it) > synchronous_commit = off > checkpoint_timeout = 1h > checkpoint_completion_target = 1 > checkpoint_warning = 0 curious about this, seems you're just looking to understand how much throughput you can get with a config that would not be used on a real system > autovacuum = off i assume you understand that autovacuum will still run when you hit 200 mil XIDs. this setting seems incongruent with the previous settings, because it seemed like you were going for throughput, which generally requires autovacuum to be more aggressive rather than less aggressive. assuming the benchmark runs for a properly sufficient length of time, this setting will slow things down because of accumulating bloat. Just a few opinions, I might be wrong, hope the feedback is helpful. :) -Jeremy -- http://about.me/jeremy_schneider
