Есть средство виртуализации debian с VirtualBox (kvm)
Поднимем, 2 виртуальные машины:
1. Ubuntu 16.04 32 Gb 4 ядра
Виртуальная машина ubuntu 16.04.5 PostgreSQL версия 10.5-24.1C 1С 8.3.13.1690
Тест pgbench
$ sudo su postgres
$ psql -c "CREATE DATABASE example;"
$ pgbench -i -s 500 example
$ pgbench -c 10 -j 10 -t 10000 example
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 1.647 ms
tps = 6073.027124 (including connections establishing)
tps = 6078.146705 (excluding connections establishing)
Тест расчета зарплаты на 3000 сотрудников (с оптимизацией postgresql.conf):
Заполнить154 с
Провести 127 с
Тест Гилева
$ cat /proc/cpuinfo | grep MHz
cpu MHz : 3599.998
cpu MHz : 3599.998
cpu MHz : 3599.998
cpu MHz : 3599.998
$ sudo hdparm -Tt /dev/sda
/dev/sda:
Timing cached reads: 34870 MB in 1.98 seconds = 17598.73 MB/sec
Timing buffered disk reads: 1096 MB in 3.00 seconds = 365.07 MB/sec
$ free -ht
total used free shared buff/cache available
Память: 31G 2,5G 1,3G 2,5G 27G 25G
Подкачка: 1,0G 7,0M 1,0G
Всего: 32G 2,5G 2,3G
2. Windows 10 32 Gb 4 ядра
Установка PostgreSQL, версия 10.5-24.1C windows 10
PostgreSQL, версия 10.5-24.1C windows 10 postgresql.conf
> "c:\Program Files\PostgreSQL\10.5-24.1C\bin\psql" -U postgres -c "CREATE DATABASE example"
Password for user postgres:
CREATE DATABASE
"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres -i -s 500 example
"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres -c 10 -j 10 -t 10000 example
C:\Users\user>"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres -c 10 -j 10 -t 10000 example
Password:
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 2.006 ms
tps = 4984.870590 (including connections establishing)
tps = 5021.018416 (excluding connections establishing)
Тест расчета зарплаты на 3000 сотрудников (с оптимизацией postgresql.conf):
Заполнить160 с
Провести 148 с
-----------------------------------------------------------------------
CrystalDiskMark 6.0.2 x64 (C) 2007-2018 hiyohiyo
Crystal Dew World : https://crystalmark.info/
-----------------------------------------------------------------------
* MB/s = 1,000,000 bytes/s [SATA/600 = 600,000,000 bytes/s]
* KB = 1000 bytes, KiB = 1024 bytes
Sequential Read (Q= 32,T= 1) : 541.779 MB/s
Sequential Write (Q= 32,T= 1) : 524.051 MB/s
Random Read 4KiB (Q= 8,T= 8) : 277.270 MB/s [ 67692.9 IOPS]
Random Write 4KiB (Q= 8,T= 8) : 252.523 MB/s [ 61651.1 IOPS]
Random Read 4KiB (Q= 32,T= 1) : 188.719 MB/s [ 46074.0 IOPS]
Random Write 4KiB (Q= 32,T= 1) : 153.639 MB/s [ 37509.5 IOPS]
Random Read 4KiB (Q= 1,T= 1) : 22.986 MB/s [ 5611.8 IOPS]
Random Write 4KiB (Q= 1,T= 1) : 59.959 MB/s [ 14638.4 IOPS]
Test : 1024 MiB [C: 5.4% (53.8/999.5 GiB)] (x5) [Interval=5 sec]
Date : 2019/03/25 18:36:32
OS : Windows 10 Professional [10.0 Build 16299] (x64)
Поднимем, 2 виртуальные машины:
1. Ubuntu 16.04 32 Gb 4 ядра
Виртуальная машина ubuntu 16.04.5 PostgreSQL версия 10.5-24.1C 1С 8.3.13.1690
Тест pgbench
$ sudo su postgres
$ psql -c "CREATE DATABASE example;"
$ pgbench -i -s 500 example
$ pgbench -c 10 -j 10 -t 10000 example
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 1.647 ms
tps = 6073.027124 (including connections establishing)
tps = 6078.146705 (excluding connections establishing)
Тест расчета зарплаты на 3000 сотрудников (с оптимизацией postgresql.conf):
Заполнить154 с
Провести 127 с
Тест Гилева
$ cat /proc/cpuinfo | grep MHz
cpu MHz : 3599.998
cpu MHz : 3599.998
cpu MHz : 3599.998
cpu MHz : 3599.998
$ sudo hdparm -Tt /dev/sda
/dev/sda:
Timing cached reads: 34870 MB in 1.98 seconds = 17598.73 MB/sec
Timing buffered disk reads: 1096 MB in 3.00 seconds = 365.07 MB/sec
$ free -ht
total used free shared buff/cache available
Память: 31G 2,5G 1,3G 2,5G 27G 25G
Подкачка: 1,0G 7,0M 1,0G
Всего: 32G 2,5G 2,3G
2. Windows 10 32 Gb 4 ядра
Установка PostgreSQL, версия 10.5-24.1C windows 10
PostgreSQL, версия 10.5-24.1C windows 10 postgresql.conf
> "c:\Program Files\PostgreSQL\10.5-24.1C\bin\psql" -U postgres -c "CREATE DATABASE example"
Password for user postgres:
CREATE DATABASE
"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres -i -s 500 example
"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres -c 10 -j 10 -t 10000 example
C:\Users\user>"c:\Program Files\PostgreSQL\10.5-24.1C\bin\pgbench" -U postgres -c 10 -j 10 -t 10000 example
Password:
starting vacuum...end.
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 500
query mode: simple
number of clients: 10
number of threads: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 2.006 ms
tps = 4984.870590 (including connections establishing)
tps = 5021.018416 (excluding connections establishing)
Тест расчета зарплаты на 3000 сотрудников (с оптимизацией postgresql.conf):
Заполнить160 с
Провести 148 с
-----------------------------------------------------------------------
CrystalDiskMark 6.0.2 x64 (C) 2007-2018 hiyohiyo
Crystal Dew World : https://crystalmark.info/
-----------------------------------------------------------------------
* MB/s = 1,000,000 bytes/s [SATA/600 = 600,000,000 bytes/s]
* KB = 1000 bytes, KiB = 1024 bytes
Sequential Read (Q= 32,T= 1) : 541.779 MB/s
Sequential Write (Q= 32,T= 1) : 524.051 MB/s
Random Read 4KiB (Q= 8,T= 8) : 277.270 MB/s [ 67692.9 IOPS]
Random Write 4KiB (Q= 8,T= 8) : 252.523 MB/s [ 61651.1 IOPS]
Random Read 4KiB (Q= 32,T= 1) : 188.719 MB/s [ 46074.0 IOPS]
Random Write 4KiB (Q= 32,T= 1) : 153.639 MB/s [ 37509.5 IOPS]
Random Read 4KiB (Q= 1,T= 1) : 22.986 MB/s [ 5611.8 IOPS]
Random Write 4KiB (Q= 1,T= 1) : 59.959 MB/s [ 14638.4 IOPS]
Test : 1024 MiB [C: 5.4% (53.8/999.5 GiB)] (x5) [Interval=5 sec]
Date : 2019/03/25 18:36:32
OS : Windows 10 Professional [10.0 Build 16299] (x64)
1С И Linux: Тест 1С И Postgresql Windows Vs Postgresql Linux >>>>> Download Now
ОтветитьУдалить>>>>> Download Full
1С И Linux: Тест 1С И Postgresql Windows Vs Postgresql Linux >>>>> Download LINK
>>>>> Download Now
1С И Linux: Тест 1С И Postgresql Windows Vs Postgresql Linux >>>>> Download Full
>>>>> Download LINK aD