Re: [PERFORM] 99% time spent in WAL wait events

Kindly ignore this post. It was an oversight - the wait times are in millisec and hence even if we manage to reduce these waits to 0, we will gain only 1000 msec of savings during a workload of 40min. Regards On 16 Oct 2017 7:04 pm, "Purav Chovatia" wrote: Hello, We are running workload on a E

[PERFORM] 99% time spent in WAL wait events

Hello, We are running workload on a EDB Postgres Advanced Server 9.6 and we see that 99% of the time is spent on WAL wait events: *System Wait Information WAIT NAME COUNT WAIT TIME % WAIT --- wal flush 564552 298.789464