Re: How to speed up commits? - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: How to speed up commits?
Date
Msg-id 3.0.5.32.20000404171639.009283f0@pop.mecomb.po.my
Whole thread Raw
In response to Re: How to speed up commits?  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
>By the way, we have been running a production PostgreSQL server
>on 6.5beta for over a year with fsync() off (-o -F) without
>problems. If your server doesn't suffer from kernel crashes, and
>is backed by a UPS, there's no reason in running PostgreSQL with
>fsync() on. It seems pretty clear that the mySQL folks didn't
>even consider a flushing option until the port to Win32, where
>the "kernel" was far from reliable...

OK tried it briefly with -o -F. Got 68 hits/sec! That's quite a remarkable
speed up from 13-15 hits/sec.

On a slower machine the speed up was only from 6 hits/s to 13 hits/s.

Switched back to sync tho. Too cowardly ;). Plus speed is not so critical
at the moment.

Well at least I know there's more juice on tap if I really need it...

Cheerio,

Link.


pgsql-general by date:

Previous
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: cursor in plpgsql
Next
From: "Andrew C.R. Martin"
Date:
Subject: Re: [ANNOUNCE] PostgreSQL book completed though chapter 10