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

From Robert Haas
Subject Re: Design proposal: fsync absorb linear slider
Date
Msg-id CA+Tgmoa-06jCUrAaOD2z3SXoPBgJWBBQq8dMPb9fK4Ch9MZtqw@mail.gmail.com
Whole thread Raw
In response to Re: Design proposal: fsync absorb linear slider  (didier <did447@gmail.com>)
Responses Re: Design proposal: fsync absorb linear slider
List pgsql-hackers
On Thu, Jul 25, 2013 at 6:02 PM, didier <did447@gmail.com> wrote:
> It was surely already discussed but why isn't postresql  writing
> sequentially its cache in a temporary file? With storage random speed at
> least five to ten time slower it could help a lot.
> Thanks

Sure, that's what the WAL does.  But you still have to checkpoint eventually.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: getting rid of SnapshotNow
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements