Re: XLog vs SSD [Was: Re: random write in xlog?] - Mailing list pgsql-hackers

From James Cloos
Subject Re: XLog vs SSD [Was: Re: random write in xlog?]
Date
Msg-id m3pqtayhv6.fsf@jhcloos.com
Whole thread Raw
In response to Re: XLog vs SSD [Was: Re: random write in xlog?]  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
>>>>> "JJ" == Jeff Janes <jeff.janes@gmail.com> writes:

JJ> So PG always writing 8K at a time is unlikely to make a difference
JJ> than if it wrote a smaller amount.

Ah.

Somehow I was thinking of the xlog files' 16M filesize rather than the
internal 8k block size....

If it is only writing 8k blocks then there is probably little hope of
making efficient use of flash.

-JimC
-- 
James Cloos <cloos@jhcloos.com>         OpenPGP: 1024D/ED7DAEA6


pgsql-hackers by date:

Previous
From: "BRUSSER Michael"
Date:
Subject: initdb failure with Postgres 8.4.4
Next
From: Gurjeet Singh
Date:
Subject: Re: Patch to add a primary key using an existing index