| From: | Matthias Meixner <meixner(at)dvs1(dot)informatik(dot)tu-darmstadt(dot)de> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Write ahead logging |
| Date: | 2003-02-20 08:42:02 |
| Message-ID: | 3E5494DA.20003@dvs1.informatik.tu-darmstadt.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)informatik(dot)tu-darmstadt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-02-20 09:17:31 | Re: Write ahead logging |
| Previous Message | Ahmad Abdul Haq | 2003-02-20 06:24:11 | Peluang Usaha yang Luar Biasa |