Друзья почему такая разница ? Amazon Aurora: postgres=> show shared_buffers; shared_buffers ----------------

Question

Друзья почему такая разница ? Amazon Aurora: postgres=> show shared_buffers; shared_buffers ----------------

10433880kB
(1 row)

starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 50
query mode: simple
number of clients: 10
number of threads: 2
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
tps = 720.672603 (including connections establishing)
tps = 720.972505 (excluding connections establishi
Ванильный постгрес на виртуалке 4ГБ оперативка:
show shared_buffers;
shared_buffers
----------------
1GB
(1 row)

transaction type: <builtin: TPC-B (sort of)>
scaling factor: 50
query mode: simple
number of clients: 10
number of threads: 2
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
latency average = 3.675 ms
tps = 2721.322204 (including connections establishing)
tps = 2721.552171 (excluding connections establishing)

#backend #devops #pgsql #programming #russian

0

22.07.2019

1 ответов

32 просмотра

Alex · Answer 1

Все также мучает этот вопрос. В гугле все пишут что aurora 3х быстрее ванильного. Почему у меня такие показатели : Aurora 10 : 16 GB RAM transaction type: TPC-B (sort of) scaling factor: 50 query mode: simple number of clients: 1 number of threads: 1 number of transactions per client: 10000 number of transactions actually processed: 10000/10000 tps = 117.852469 (including connections establishing) tps = 117.868912 (excluding connections establishing) VPS Postgres10 : 4GB RAM transaction type: <builtin: TPC-B (sort of)> scaling factor: 50 query mode: simple number of clients: 1 number of threads: 1 number of transactions per client: 10000 number of transactions actually processed: 10000/10000 latency average = 0.988 ms tps = 1012.318682 (including connections establishing) tps = 1012.647044 (excluding connections establishing)

172 похожих чатов

Друзья почему такая разница ? Amazon Aurora: postgres=> show shared_buffers; shared_buffers ----------------

1 ответов

Похожие вопросы