As Greg suggested, update you all that each vm has its own dedicated esx. Every esx has it`s own local disks. I run it one time on two different servers that has the same hardware and same postgresql db (version and conf). The results : pgbench -i -s 6 pgbench -p 5432 -U postgres pgbench -c 16 -j 4 -T 5 -U postgres pgbench MACHINE 1 starting vacuum...end. transaction type: <builtin: TPC-B (sort of)> scaling factor: 6 query mode: simple number of clients: 16 number of threads: 4 duration: 5 s number of transactions actually processed: 669 latency average = 122.633 ms tps = 130.470828 (including connections establishing) tps = 130.620286 (excluding connections establishing)
MACHINE 2 pgbench -c 16 -j 4 -T 600 -U postgres -p 5433 pgbench starting vacuum...end. transaction type: <builtin: TPC-B (sort of)> scaling factor: 6 query mode: simple number of clients: 16 number of threads: 4 duration: 600 s number of transactions actually processed: 2393723 latency average = 4.011 ms tps = 3989.437514 (including connections establishing) tps = 3989.473036 (excluding connections establishing) any idea what can cause such a difference ? Both of the machines have 20core and 65GB of ram. בתאריך יום ה׳, 13 בדצמ׳ 2018 ב-15:54 מאת Mariel Cherkassky < mariel.cherkas...@gmail.com>: > Ok, I'll do that. Thanks . > > בתאריך יום ה׳, 13 בדצמ׳ 2018 ב-15:54 מאת Greg Clough < > greg.clo...@ihsmarkit.com>: > >> Hmmm... sounds like you’ve got most of it covered. It may be a good idea >> to send that last message back to the list, as maybe others will have >> better ideas. >> >> >> >> Greg. >> >> >> >> *From:* Mariel Cherkassky <mariel.cherkas...@gmail.com> >> *Sent:* Thursday, December 13, 2018 1:45 PM >> *To:* Greg Clough <greg.clo...@ihsmarkit.com> >> *Subject:* Re: pgbench results arent accurate >> >> >> >> Both of the machines are the only vms in a dedicated esx for each one. >> Each esx has local disks. >> >> >> >> On Thu, Dec 13, 2018, 3:05 PM Greg Clough <greg.clo...@ihsmarkit.com >> wrote: >> >> > I installed a new postgres 9.6 on both of my machines. >> >> >> >> Where is your storage? Is it local, or on a SAN? A SAN will definitely >> have a cache, so possibly there is another layer of cache that you’re not >> accounting for. >> >> >> >> Greg Clough. >> >> >> ------------------------------ >> >> >> This e-mail, including accompanying communications and attachments, is >> strictly confidential and only for the intended recipient. Any retention, >> use or disclosure not expressly authorised by IHSMarkit is prohibited. This >> email is subject to all waivers and other terms at the following link: >> https://ihsmarkit.com/Legal/EmailDisclaimer.html >> >> Please visit www.ihsmarkit.com/about/contact-us.html for contact >> information on our offices worldwide. >> >> >> ------------------------------ >> >> This e-mail, including accompanying communications and attachments, is >> strictly confidential and only for the intended recipient. Any retention, >> use or disclosure not expressly authorised by IHSMarkit is prohibited. This >> email is subject to all waivers and other terms at the following link: >> https://ihsmarkit.com/Legal/EmailDisclaimer.html >> >> Please visit www.ihsmarkit.com/about/contact-us.html for contact >> information on our offices worldwide. >> >
