Postgres Pro
Downloads
Home   >   mailing lists

Re: how unsafe (or worst scenarios) when setting fsync - Mailing list pgsql-performance

From Markus Schaber
Subject Re: how unsafe (or worst scenarios) when setting fsync
Date
Msg-id 4451D95E.9080308@logix-tt.com
Whole thread Raw
In response to Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql  ("Guoping Zhang" <guoping.zhang@nec.com.au>)
List pgsql-performance
Tree view 
Hk, Guoping,

Guoping Zhang wrote:

> a) The tests consists of ten thousands very small transactions, which are
> not grouped, that is why so slow with compare to set fsync off.

If those transactions are submitted by concurrent applications over
several simulataneous connections, playing with commit_delay and
commit_siblins may improve your situation.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

pgsql-performance by date:

Previous
From: "Mikael Carneholm"
Date:
Subject: Re: how unsafe (or worst scenarios) when setting fsync OFF for postgresql
Next
From: "Andrus"
Date:
Subject: Re: CPU usage goes to 100%, query seems to ran forever