From: | "Leonardo Francalanci" <lfrancalanci(at)simtel(dot)ie> |
---|---|
To: | "postgresql" <pgsql-general(at)postgresql(dot)org> |
Subject: | what is flushed? |
Date: | 2004-09-15 14:10:29 |
Message-ID: | KNEFJLENOMMIGOKNCBFAMEPMEOAA.lfrancalanci@simtel.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I was reading "Don't be lazy, be consistent: Postgres-R,
a new way to implement Database Replication"
and I found this:
"5.1 General configuration
PostgreSQL uses a force strategy to avoid redo recovery,
flushing all dirty buffer pages at the end of each
transaction. With this strategy, response times are
very poor. This makes it difficult to compare with
commercial systems which only flush redo logs to disk.
To allow us to use a more ``realistic'' setting we used
the noflush option offered by PostgreSQL. With this
option nothing is forced to disk, not even a log record.
This, of course, violates the ACID properties, how
ever the measured response time was better comparable
to standard database systems."
The doc uses Postgresql version 6.4.2.
Has this behaviour been changed?
>From the docs of the 7.4 I got that only the redo logs are flushed...
Or am I wrong?
From | Date | Subject | |
---|---|---|---|
Next Message | John Sidney-Woollett | 2004-09-15 14:19:34 | psql + autocommit |
Previous Message | Tom Lane | 2004-09-15 14:08:47 | Re: Checking regex pattern validity |