Re: Design proposal: fsync absorb linear slider - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Design proposal: fsync absorb linear slider
Date
Msg-id 13245.1374841921@sss.pgh.pa.us
Whole thread Raw
In response to Re: Design proposal: fsync absorb linear slider  (Greg Smith <greg@2ndQuadrant.com>)
Responses Re: Design proposal: fsync absorb linear slider
Re: Design proposal: fsync absorb linear slider
List pgsql-hackers
Greg Smith <greg@2ndQuadrant.com> writes:
> On 7/26/13 5:59 AM, Hannu Krosing wrote:
>> Well, SSD disks do it in the way proposed by didier (AFAIK), by putting
>> "random"
>> fs pages on one large disk page and having an extra index layer for
>> resolving
>> random-to-sequential ordering.

> If your solution to avoiding random writes now is to do sequential ones 
> into a buffer, you'll pay for it by having more expensive random reads 
> later.

What I'd point out is that that is exactly what WAL does for us, ie
convert a bunch of random writes into sequential writes.  But sooner or
later you have to put the data where it belongs.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: inconsistent state after crash recovery
Next
From: Tom Lane
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])