...every cal has it's advantages and disadvantages. The 9mm is the same diameter as the .38 or the .357 magnum. The same projectile can be loaded in any of them if you are of the reloading sort. The .45 is a bigger diameter. The .357 is a faster projectile because of the load behind it. The standard .38 is less than 1000 fps the 9mm is usually 1000 or a little more. Advantage of the .38 is that revolvers don't jam unless you let em rust up really bad.
...the model 92 beretta 9mm is an awfully heavy gun for such a light calibre cartridge. My former 9mm was a S&W that I bought from a former cop and I traded it for a .40 cal also an S&W. It shoots a 160 grain projectile at a bit over 1000 fps. My .45 shoots a 230 grain projectile at around 1000 fps also. The .45 does not have to penetrate body armor to disable the target. 230 grains is right at half an ounce and 1000 fps is 681 mph. It's like getting hit by a bus.
...the 9mm is one ya can get back on target with quickly so ya can just double tap the target. The 9mm will also give you a greater number of shots in a magazine.
...as to what I would prefer if I was going after a perp who was barricaded and an active shooter?