-performance@postgresql.org
Cc: Guoping Zhang (E-mail)
Subject: [PERFORM] how unsafe (or worst scenarios) when setting fsync OFF for
postgresql
Hi,.
We are new to Postgresql. I am appreciated if the following question can be
answered.
Our application has a strict speed requirement for DB
Hi,.
We are new to Postgresql. I am appreciated if the following question can be
answered.
Our application has a strict speed requirement for DB operation. Our tests
show that it takes about 10secs for the operation when setting fsync off,
but takes about 70 seconds when setting fsync ON (with
)
Subject: [PERFORM] how unsafe (or worst scenarios) when setting fsync
OFF for postgresql
Hi,.
We are new to Postgresql. I am appreciated if the following question can
be answered.
Our application has a strict speed requirement for DB operation. Our
tests show that it takes about 10secs
Guoping,
On 4/27/06, Guoping Zhang [EMAIL PROTECTED] wrote:
We have to looking at setting fsync OFF option for performance reason,
Did you try the other wal sync methods (fdatasync in particular)? I
saw a few posts lately explaining how changing sync method can affect
performances in specific
Guoping Zhang [EMAIL PROTECTED] writes:
Our application has a strict speed requirement for DB operation. Our tests
show that it takes about 10secs for the operation when setting fsync off,
but takes about 70 seconds when setting fsync ON (with other WAL related
parametered tuned).
I can't
: 2006Äê4ÔÂ28ÈÕ 0:53
To: [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org; Guoping Zhang (E-mail)
Subject: Re: [PERFORM] how unsafe (or worst scenarios) when setting
fsync OFF for postgresql
Guoping Zhang [EMAIL PROTECTED] writes:
Our application has a strict speed requirement for DB operation
Guoping Zhang [EMAIL PROTECTED] writes:
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.
Yup.
c) wal_sync_method is set to 'open_datasync', which is fastest among the
four, right?
Well, is it? You
Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: 2006Äê4ÔÂ28ÈÕ 14:57
To: [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org; 'Guoping Zhang (E-mail)'
Subject: Re: [PERFORM] how unsafe (or worst scenarios) when setting
fsync OFF for postgresql
Guoping Zhang [EMAIL PROTECTED] writes