Size: a a a
GS
СГ
LK
GS
GS
СГ
root@sql# time /opt/pgpro/1c-11/bin/pgbench -U postgres -i -s 1000 pgbenchвторой результат это на кластере с отключенными чексуммами
....
100000000 of 100000000 tuples (100%) done (elapsed 76.33 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.
real 4m54.682s
user 0m13.867s
sys 0m0.314s
root@sql# time /opt/pgpro/1c-11/bin/pgbench -U postgres -i -s 1000 pgbench
....
100000000 of 100000000 tuples (100%) done (elapsed 67.62 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.
real 2m14.153s
user 0m14.322s
sys 0m0.364s
GS
root@sql# time /opt/pgpro/1c-11/bin/pgbench -U postgres -i -s 1000 pgbenchвторой результат это на кластере с отключенными чексуммами
....
100000000 of 100000000 tuples (100%) done (elapsed 76.33 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.
real 4m54.682s
user 0m13.867s
sys 0m0.314s
root@sql# time /opt/pgpro/1c-11/bin/pgbench -U postgres -i -s 1000 pgbench
....
100000000 of 100000000 tuples (100%) done (elapsed 67.62 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.
real 2m14.153s
user 0m14.322s
sys 0m0.364s
GS
root@sql# time /opt/pgpro/1c-11/bin/pgbench -U postgres -i -s 1000 pgbenchвторой результат это на кластере с отключенными чексуммами
....
100000000 of 100000000 tuples (100%) done (elapsed 76.33 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.
real 4m54.682s
user 0m13.867s
sys 0m0.314s
root@sql# time /opt/pgpro/1c-11/bin/pgbench -U postgres -i -s 1000 pgbench
....
100000000 of 100000000 tuples (100%) done (elapsed 67.62 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.
real 2m14.153s
user 0m14.322s
sys 0m0.364s
GS
СГ
GS
AF
GS
СГ
synchronous_commit = off # default on, synchronization level;
full_page_writes = off # default on, recover from partial page writes
wal_init_zero = off # default on, zero-fill new WAL files
wal_recycle = off # default on, recycle WAL files
GS
synchronous_commit = off # default on, synchronization level;
full_page_writes = off # default on, recover from partial page writes
wal_init_zero = off # default on, zero-fill new WAL files
wal_recycle = off # default on, recycle WAL files
GS
synchronous_commit = off # default on, synchronization level;
full_page_writes = off # default on, recover from partial page writes
wal_init_zero = off # default on, zero-fill new WAL files
wal_recycle = off # default on, recycle WAL files
GS
synchronous_commit = off # default on, synchronization level;
full_page_writes = off # default on, recover from partial page writes
wal_init_zero = off # default on, zero-fill new WAL files
wal_recycle = off # default on, recycle WAL files
СГ
GS
СГ
