Re: RE: Sizing of LARGE databases. - Mailing list pgsql-novice

From Einar Karttunen
Subject Re: RE: Sizing of LARGE databases.
Date
Msg-id Pine.LNX.4.30.0102071501470.10592-100000@melkinpaasi.cs.Helsinki.FI
Whole thread Raw
In response to Re: RE: Sizing of LARGE databases.  (Francisco Reyes <fran@reyes.somos.net>)
Responses Re: Re: RE: Sizing of LARGE databases.  (Francisco Reyes <fran@reyes.somos.net>)
List pgsql-novice
On Tue, 6 Feb 2001, Francisco Reyes wrote:
> On Wed, 7 Feb 2001, Justin Clift wrote:
>
> > In PostgreSQL 7.1 though, there is apparently no need to use -F at all.
>
> Why?
> I read on the  "todo" list a plan to do fsync less often, but didn't see a
> mention they were doing something so it would have the performance of "-F"
> without it's risks.
>
> What did you read that gave you that impression?
>
from the release notes of v.7.1 beta
Write-Ahead Log (WAL) to provide crash recovery with less performance overhead (Vadim)

that means that only the log has to be written to the disk not the entire
transaction.

- Einar


pgsql-novice by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: RE: Sizing of LARGE databases.
Next
From: Tatsuo Ishii
Date:
Subject: Re: [GENERAL] Re: Re: Sizing of LARGE databases.