| From: | Subhrajyoti Senapati <ssubhrajyoti(at)google(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Sysbench tests on PG12 |
| Date: | 2021-10-01 08:52:23 |
| Message-ID: | CABHJmOJrfy0Ug8=3LzQq-ukT+Ly+Z=A_GNwAkb7b2tDd2MgoCg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
[image: 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:
[image: 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oskar Stenberg | 2021-10-01 10:12:07 | Where can I find the pg_config binary in PostgreSQL 14? |
| Previous Message | Peter J. Holzer | 2021-09-30 09:55:14 | Re: Using a single sequence for all tables |