Re: 8.3 synchronous_commit

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



* Guillaume Smet:

> On Jan 22, 2008 9:32 AM, Florian Weimer <fweimer@xxxxxx> wrote:
>> > Maybe it's just my test box.. single SATA-II drive, XFS on top of LVM.
>>
>> Ours was ext3, no LVM or RAID.
>
> Also with SATA?

Yes, desktop-class SATA.

> If your SATA disk is lying about effectively SYNCing the data, I'm
> not that surprised you don't see any improvement.

It still should be faster since the commit doesn't even have to leave
the kernel write cache.  For us, this is the common case because most
non-desktop systems have battery-backed write cache anyway.

> Being slower is a bit surprising though.

Exactly.

-- 
Florian Weimer                <fweimer@xxxxxx>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux