0

I have a java application writing and reading some data on postgress database. On running long duration test i see failures after a continues buildup of IO waits. Any suggestions to further dig down on what could be causing this IO buildup

enter image description here

Anmol Dubey
  • 115
  • 2
  • 13
  • 1
    Tune your statements so that they do less I/O, or get a stronger disk. – Laurenz Albe Dec 02 '22 at 16:37
  • 1
    Check your queries, which queries cause most of the io? – Frank Heikens Dec 02 '22 at 17:46
  • It could be anything from get faster disks, to get more RAM to better cache data, to build an index to make your queries more efficient. Using auto_explain to get the execution plans of the slowest queries is probably the best way to figure out if you can do the last of those. – jjanes Dec 02 '22 at 20:05

0 Answers0