From 8d1c1d40ec25424d08539cdd358cfcc437adeb63 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 11 Jun 2002 02:22:41 +0000 Subject: Update fsync FAQ item. --- doc/src/FAQ/FAQ.html | 34 +++++++++++----------------------- 1 file changed, 11 insertions(+), 23 deletions(-) (limited to 'doc/src/FAQ/FAQ.html') diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index d40aa45f36a..2f4a0e6a5a4 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -14,7 +14,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Mon Jun 10 16:44:55 EDT 2002

+

Last updated: Mon Jun 10 22:22:31 EDT 2002

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -425,32 +425,20 @@

Performance
-
PostgreSQL runs in two modes. Normal fsync mode - flushes every completed transaction to disk, guaranteeing that if - the OS crashes or loses power in the next few seconds, all your - data is safely stored on disk. In this mode, we are slower than - most commercial databases, partly because few of them do such - conservative flushing to disk in their default modes. In - no-fsync mode, we are usually faster than commercial - databases, though in this mode, an OS crash could cause data - corruption. We are working to provide an intermediate mode that - suffers less performance overhead than full fsync mode, and will - allow data integrity within 30 seconds of an OS crash.
+
PostgreSQL has performance similar to other commercial and + open source databases. it is faster for some things, slower for + others.
- In comparison to MySQL or leaner database systems, we are slower + In comparison to MySQL or leaner database systems, we are slower on inserts/updates because we have transaction overhead. Of course, MySQL does not have any of the features mentioned in the - Features section above. We are built for flexibility and - features, though we continue to improve performance through - profiling and source code analysis. There is an interesting Web - page comparing PostgreSQL to MySQL at http://openacs.org/why-not-mysql.html
+ Features section above. We are built for reliability and + features, though we continue to improve performance in every + release. There is an interesting Web page comparing PostgreSQL to + MySQL at + + http://openacs.org/why-not-mysql.html
-
- We handle each user connection by creating a Unix process. - Backend processes share data buffers and locking information. - With multiple CPUs, multiple backends can easily run on different - CPUs.

-- cgit v1.2.3