Postgres Pro
Downloads
Home   >   mailing lists

huge difference in TPS depending of synchornous_commit setting - Mailing list pgsql-novice

From Sergey Kirillov
Subject huge difference in TPS depending of synchornous_commit setting
Date
Msg-id CAJjUSnD8YJn3H3UP6tPLWaqntOgZbW-AV_qPhNi6gr8d8XNgYA@mail.gmail.com
Whole thread Raw
Responses Re: huge difference in TPS depending of synchornous_commit setting  (Jesper Krogh <jesper@krogh.cc>)
Re: huge difference in TPS depending of synchornous_commit setting  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-novice
Tree view
Hi. 

I'm having problems with PostgreSQL performance.

My server has good CPU and lots of memory, but just two SATA 7200 hard drives in software RAID1.

When running pgbench I'm getting 68 TPS with synchronous_commit turned on, and 3100 TPS with synchronous commit turned off.

Can somebody tell me why there is such big difference? Is it normal to have it like this?

PS: During run of pgbench with synchronous commit on system is mostly idle, iowait is 0.12%

--
Best regards,
  Sergey

pgsql-novice by date:

Previous
From: Antonio Carlos Salzvedel Furtado Junior
Date:
Subject: Performance issue with virtualized DB
Next
From: Jesper Krogh
Date:
Subject: Re: huge difference in TPS depending of synchornous_commit setting