Write ahead logging
| От | Matthias Meixner |
|---|---|
| Тема | Write ahead logging |
| Дата | |
| Msg-id | 3E5494DA.20003@dvs1.informatik.tu-darmstadt.de обсуждение |
| Ответы |
Re: Write ahead logging
|
| Список | pgsql-performance |
Hi
I am doing some performance testing using postgresql. When measuring the
latency of commit I got some results, which make me doubt, if the logging
data is written to disk in time:
Using a slow disk (5400rpm) I measured about 3-5 ms for a commit. But
average rotational delay is already higher for that disk (5.5ms).
So the question is: has anybody verified, that the log is written to disk
before returning from commit?
System used was:
Linux 2.4.20
filesystem: ext3
postgresql postgresql-7.2
Regards,
Matthias Meixner
--
Matthias Meixner meixner@informatik.tu-darmstadt.de
Technische Universität Darmstadt
Datenbanken und Verteilte Systeme Telefon (+49) 6151 16 6232
Wilhelminenstraße 7, D-64283 Darmstadt, Germany Fax (+49) 6151 16 6229
В списке pgsql-performance по дате отправления: