Sysbench tests on PG12

Поиск
Список
Период
Сортировка
От Subhrajyoti Senapati
Тема Sysbench tests on PG12
Дата
Msg-id CABHJmOJrfy0Ug8=3LzQq-ukT+Ly+Z=A_GNwAkb7b2tDd2MgoCg@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Hi,

Was running a few sysbench tests in Postgres12.
Sysbench Test Config
oltp-readwrite-custom
Threads - 500
Machine: 16 core 64G

In PG server:
shared_buffers: 16GB
maintenance_work_memory: 16GB
checkpoint_timeout: 1h
max_wal_size: 10GB
wal_sync_method: 'open_sync'
effective_cache_size: 32GB
wal_buffers: -1
wal_compression: on

line-graph (6).png
Got some qps dips.

Changed fsync and full_page_rewrite to 'off'.
Which helped in avoiding these many long dips in performance:

line-graph (9).png
But fsync ensures DBMS consistency. So, instead of that can I change a few other configurations to avoid these inconsistent performance dips ?

Regards,
Subhrajyoti

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Using a single sequence for all tables
Следующее
От: Oskar Stenberg
Дата:
Сообщение: Where can I find the pg_config binary in PostgreSQL 14?