Re: Design proposal: fsync absorb linear slider

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: didier <did447(at)gmail(dot)com>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Design proposal: fsync absorb linear slider
Date: 2013-07-25 23:53:01
Message-ID: CA+Tgmoa-06jCUrAaOD2z3SXoPBgJWBBQq8dMPb9fK4Ch9MZtqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 25, 2013 at 6:02 PM, didier <did447(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2013-07-26 00:44:09 Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements
Previous Message Robert Haas 2013-07-25 23:24:53 Re: getting rid of SnapshotNow