понедельник, 25 марта 2019 г.

Тест 1С и PostgreSQL Windows vs PostgreSQL Linux

Есть средство виртуализации 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)
 


1 комментарий:

  1. 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

    ОтветитьУдалить