Re: RE: Sizing of LARGE databases.

From: Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI>
To: Francisco Reyes <fran(at)reyes(dot)somos(dot)net>
Cc: Justin Clift <aa2(at)bigpond(dot)net(dot)au>, Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: RE: Sizing of LARGE databases.
Date: 2001-02-07 13:03:13
Message-ID: Pine.LNX.4.30.0102071501470.10592-100000@melkinpaasi.cs.Helsinki.FI
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Conrad Schuler 2001-02-07 19:32:05 Recasting data type
Previous Message Francisco Reyes 2001-02-07 04:16:10 Re: RE: Sizing of LARGE databases.