| From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
|---|---|
| To: | Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com> |
| Subject: | Re: 8.3 synchronous_commit |
| Date: | 2008-01-22 11:56:59 |
| Message-ID: | 4795DA0B.7000202@theendofthetunnel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Guillaume Smet wrote:
> Also with SATA? If your SATA disk is lying about effectively SYNCing
> the data, I'm not that surprised you don't see any improvement. Being
> slower is a bit surprising though.
The disc is not lying, but LVM does not support write barriers, so the
result is the same. Indeed nothing is flushing the disc's write cache on
fsync. However I could disable the disc's write cache entirely. One
reason why I'm a ZFS fan boy lately. It just get's all of this right by
*default*.
Anyway, with some further testing my benchmark results vary so much that
further discussion seems pointless. I'll repost when I really have
reproducible values and followed Greg Smith's advice.
--
Best regards,
Hannes Dorbath
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannes Dorbath | 2008-01-22 12:13:57 | Re: 8.3 synchronous_commit |
| Previous Message | Florian Weimer | 2008-01-22 08:56:51 | Re: 8.3 synchronous_commit |