Hideyuki Kawashima wrote:
> Hello PostgreSQL Hackers,
>
> I have made a modification of PostgreSQL which accelerates INSERT/UPDATE
> using UPS. The name of the software is "Sigres", and the philosophy is
> considering a battery supplied memory as a persistent device instead of a
> disk. You can download Sigres from http://sourceforge.jp/projects/sigres/ .
>
> In the maximum case, Sigres is 7 times faster than PostgreSQL default
> (fsync=on) in my environment (CoreDuo 2.66GHz, UDMA/133), and it is also 10%
> faster than PostgreSQL without fsync (fsync=off).
Interesting and what happens when the UPS fails? My main concern is that
one of the purposes of PostgreSQL is data integrity. I am all for every
performance enhancement we can achieve, that does *not* sacrifice that.
Sincerely,
Joshua D. Drake
>
> The magic lies in usually skipping XLogWrite() and ignoring WALWriteLock. The
> exceptions are XLogWrite() calls from AdvanceXLInsertBuffer(). In addition,
> in XLogFileClose() issue_xlog_fsync() before close(). (In this point, Sigres
> is different from just simply setting fsync=off.)
>
> Although I think Sigres can be considered as one of the future directions of
> PostgreSQL, I do not know whether this software can be accepted or not. Could
> you please give me some comments ?
>
> Best Regards,
>
> -- Hideyuki Kawashima
> Assistant Professor, University of Tsukuba
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
